Extensions
Full-text search
FTS5, FTS4, and FTS3 indexes with BM25 ranking, highlighting, and snippets
Vector search
Vector columns, distance functions, and approximate nearest neighbor indexes
Spatial
R*Tree range indexes and Geopoly polygon queries
JSON
Build, query, modify, and aggregate JSON and JSONB
Regular expressions
The REGEXP operator and the regexp and regexpi functions
Identifiers and hashing
UUID generation and SHA-3 hashing
Mathematics
Trigonometric, logarithmic, and rounding functions
Statistics and text
Median, quartile, and deviation aggregates plus string helpers
Sequences
The generate_series table-valued function
Introspection
Space usage, open statements, and pragmas as tables
Syntax extensions
Alter a column in place and random row IDs
Connection settings
Settings that differ from SQLite, unsupported statements, and limits
Core functions
Standard SQLite functions and statement features
Connection functions
Two functions report on the current connection:Standard SQLite features
The standard SQLite 3.45 scalar, aggregate, window, and date and time functions are all available, along withSTRICT tables, RETURNING, UPSERT, generated columns, and common table expressions. See Core functions for the full list and what is missing.