Operator: AIMAP

Description

The AIMAP operator is a semantic mapping function that transforms column content according to a natural-language instruction. It specifies a column to which the instruction is applied. This column must be of SQL type TEXT, and can contain multimodal (text-encoded) content such as images or audio data, in addition to pure text.

Syntax

To integrate the AI map in an SQL query, use the syntax:

AIMAP(<column>, '<mapping_instruction>')

The semantics of the parameters are as follows:

• <column>: SQL column (TEXT) containing text, images, or audio data.
• <mapping_instruction>: text describing extraction, transformation, or summarization.

The operator returns one TEXT output per row. Output content follows the mapping instruction and is not restricted to a fixed schema.

Example

The following query summarizes support call audio stored in the content column of the support_calls table:

SELECT filename,
       AIMAP(content, 'summarize this audio in one sentence') AS summary
FROM support_calls;