Operator: AIMAP

Syntax: AIMAP(<qualified_column>, '<mapping_instruction>')

Parameters

• <qualified_column>: qualified SQL column (TEXT) containing 📝 text, 🖼️ image, or 🔊 audio values.
• <mapping_instruction>: 📝 instruction describing extraction, transformation, or summarization.

Output semantics

• Returns one TEXT output 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.