SQLite Features You Didn’t Know It Had: JSON, text search, CTE, STRICT, generated columns, WAL

SQLite packs JSON extraction, expression indexes, FTS5 full-text search, CTEs, window functions, and WAL into a single file. It enforces strict tables, supports generated columns, and indexes JSON expressions for fast semi-structured queries.