Operator: AIFILTER

Syntax: AIFILTER(<qualified_column>, '<natural_language_condition>')

Parameters

• <qualified_column>: qualified SQL column (TEXT) containing 📝 text, 🖼️ image, or 🔊 audio values.
• <natural_language_condition>: 📝 condition describing what should match.

Output semantics

• Returns BOOLEAN (true/false) for each input row.
• Intended for predicates in WHERE clauses.

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
FROM cars_images
WHERE AIFILTER(content, 'this is a red car');

Tips

• Phrase conditions as clear yes/no checks.
• Prefer concrete wording over broad prompts.