Fundamentals: Analytics

SamtSQL extends SQL with AI operators for multimodal analytics on relational data.

AI Operators

The SQL extensions include five AI operators:

• AIFILTER: semantic boolean filtering with user-defined condition
• AICLASSIFY: assignment of one label from a user-defined label set
• AISCORE: semantic scoring in a user-defined numeric range
• AIMAP: semantic extraction, transformation, or summarization
• AIJOIN: semantic matching between values from two tables

Operator details:

• AIFILTER
• AICLASSIFY
• AISCORE
• AIMAP
• AIJOIN

SamtSQL automatically detects stored data types (text, image, audio) and selects suitable LLM models for each operator call.

Rejected statement types

SamtSQL executes only SELECT statements (including set operations such as UNION and CTEs). UPDATE, DELETE, INSERT, CREATE, DROP, and other statement types are rejected with an error message. Statements that combine non-SELECT shapes with semantic operators (e.g. DELETE FROM t WHERE AIFILTER(...)) are rejected as well because AI operators are currently supported only inside SELECT queries.