SQL overview

Dialect summary for ToraDB SQL

ToraDB SQL supports catalog, DDL, retrieval SELECT, and analytics SELECT. Statements are case-insensitive for keywords.

Statement types

Category	Examples
Catalog	SHOW TABLES, DESCRIBE t, SHOW MATERIALIZED VIEWS
DDL	CREATE TABLE, CREATE INDEX, DROP TABLE, COMPACT TABLE
Retrieval	SELECT ... SPARSE SEARCH ..., VECTOR SEARCH ..., BOOST, DECAY, FACETS, HIGHLIGHT
Analytics	SELECT agg ... GROUP BY, WHERE, HAVING
Functions	scalar functions (lower, length, date_trunc, …) and AS aliases
Views	CREATE MATERIALIZED VIEW, REFRESH, DROP

Result shapes

• Retrieval SELECT → ranked ids/scores (SearchResults in Python)
• GROUP BY / aggregates → tabular analytics
• DDL / DESCRIBE → text message

Pages

• DDL
• Retrieval
• Functions & aliases
• Analytics
• Materialized views

Tutorial: SQL guide.