SQLite SQL Syntax Support

SQLite is the world's most widely deployed database engine — an embedded, serverless, single-file relational database used in browsers, mobile apps, and countless applications. Its SQL dialect includes distinctive features such as flexible type affinity, INSERT ... ON CONFLICT (UPSERT), WITHOUT ROWID tables, and ATTACH DATABASE.

General SQL Parser (GSP) parses SQLite SQL with a dedicated grammar, producing a full AST for syntax validation, formatting, SQL rewriting, and column-level data lineage — all offline, with no database connection required.

See the SQLite Keyword Compatibility Reference for which keywords can be used as unquoted identifiers.