docs/sql-reference/compatibility.mdx
The authoritative compatibility reference is maintained at COMPAT.md in the repository root. It tracks the support status for every SQL statement, expression, function, PRAGMA, C API function, VDBE opcode, and extension.
Refer to that document for the current state of compatibility. It is updated alongside code changes to stay accurate.
These features extend Turso beyond SQLite compatibility:
| Feature | Description |
|---|---|
| CREATE TYPE | User-defined types for STRICT tables |
| CREATE MATERIALIZED VIEW | Live materialized views with incremental maintenance |
| BEGIN CONCURRENT | Optimistic concurrent write transactions (MVCC) |
| Vector functions | Vector storage, distance calculations, similarity search |
| Full-text search | Tantivy-powered FTS with BM25 scoring |
| CDC | Change Data Capture via PRAGMA |
| Encryption | At-rest database encryption |
| Custom index methods | CREATE INDEX ... USING for FTS and custom access methods |
| stddev() | Standard deviation aggregate function |
| DEFAULT in VALUES | SQL-standard DEFAULT keyword in INSERT VALUES lists |