| 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 |
