CREATE TABLE INSERT SELECT WHERE ORDER BY LIMIT UPDATE DELETE DISTINCT Aliases

AND OR NOT IN BETWEEN LIKE GLOB IS NULL CASE expression COALESCE NULLIF CAST

INNER JOIN LEFT JOIN CROSS JOIN Self join GROUP BY HAVING COUNT SUM AVG MIN MAX GROUP_CONCAT FILTER clause

PRIMARY KEY INTEGER PRIMARY KEY rowid UNIQUE NOT NULL CHECK FOREIGN KEY Generated columns STRICT tables WITHOUT ROWID ALTER TABLE

CREATE INDEX Composite index Partial index Expression index UNIQUE index EXPLAIN QUERY PLAN ANALYZE PRAGMA optimize Covering index concept Index selectivity

BEGIN transaction COMMIT ROLLBACK SAVEPOINT ROLLBACK TO Deferred transaction Immediate transaction Exclusive transaction WAL mode Busy timeout

datetime() strftime() json_extract() json_each() printf() instr() substr() replace() random() changes()

Common table expressions Recursive CTE Window ROW_NUMBER Window LAG UPSERT ON CONFLICT RETURNING clause ATTACH DATABASE VACUUM FTS5 virtual table Triggers