Operator: AIMAP
Syntax: AIMAP(<qualified_column>, '<mapping_instruction>')
Parameters
<qualified_column>: qualified SQL column (TEXT) containing📝 text,🖼️ image, or🔊 audiovalues.<mapping_instruction>:📝instruction describing extraction, transformation, or summarization.
Output semantics
- Returns one
TEXToutput per row. - Output content follows the mapping instruction and is not restricted to a fixed schema.
Columns containing text, images, or audio files always use SQL type TEXT. Images and audio files are encoded as text and automatically recognized by GesamtDB.
Example
SELECT filename,
AIMAP(content, 'summarize this audio in one sentence') AS summary
FROM support_calls;
Tips
- Specify desired format in the instruction (for example,
"one sentence","comma-separated tags"). - Keep instructions task-focused and concise.