Operator: AICLASSIFY

Syntax: AICLASSIFY(<qualified_column>, '<label_1>', '<label_2>'[, ...])

Parameters

• <qualified_column>: qualified SQL column (TEXT) containing 📝 text, 🖼️ image, or 🔊 audio values.
• <label_1>, <label_2>, ...: 📝 class labels (at least two).

Output semantics

• Returns one TEXT class label per row.
• Output is one of the provided labels whenever classification succeeds.
• If output cannot be mapped to a valid class, returns "Unable to classify".

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,
       AICLASSIFY(content, 'red car', 'black car', 'other') AS class_label
FROM cars_images;

Tips

• Use short, mutually exclusive labels.
• Keep label sets focused; too many similar labels reduce reliability.