Expand description
SQLRite SQL dialect.
Wraps sqlparser’s SQLiteDialect so we get every SQLite-specific
tokenizer/parser quirk (delimited identifiers, NOTNULL operator,
LIMIT a, b, MATCH/REGEXP infix, …) and overrides only what we
need for SQLRite’s vector extensions:
supports_create_index_with_clause = true— lets the parser acceptCREATE INDEX … USING hnsw (col) WITH (metric = 'cosine'). sqlparser’sSQLiteDialectreturnsfalsefrom this method, so the WITH clause would otherwise be parked inindex_options(or error). The PostgreSQL dialect already turns it on; we copy that behaviour here without taking the rest of the pgsql parser divergences.
Add new dialect overrides here as the surface grows; everything not explicitly listed defers to the base SQLite dialect.