SQLite 3.9 Adds The JSON1 Extension Module, FTS5

SQLite 3.9.0 was released today as a significant step forward for this widely-used, self-contained database engine.

SQLite 3.9 adds the JSON1 extension module, Full Text Search version 5, support for indexes on expressions, and a variety of other fixes and improvements. Here's the list of major enhancements:

- Added the json1 extension module in the source tree, and in the amalgamation. Enable support using the SQLITE_ENABLE_JSON1 compile-time option.
- Added Full Text Search version 5 (FTS5) to the amalgamation, enabled using SQLITE_ENABLE_FTS5. FTS5 will be considered "experimental" (subject to incompatible changes) for at least one more release cycle.
- The CREATE VIEW statement now accepts an optional list of column names following the view name.
- Added support for indexes on expressions.
- Added support for table-valued functions in the FROM clause of a SELECT statement.
- Added support for eponymous virtual tables.
- A VIEW may now reference undefined tables and functions when initially created. Missing tables and functions are reported when the VIEW is used in a query.
- Added the sqlite3_value_subtype() and sqlite3_result_subtype() interfaced (used by the json1 extension).
- The query planner is now able to use partial indexes that contain AND-connected terms in the WHERE clause.
- The sqlite3_analyzer.exe utility is updated to report the depth of each btree and to show the average fanout for indexes and WITHOUT ROWID tables.
- Enhanced the dbstat virtual table so that it can be used as a table-valued function where the argument is the schema to be analyzed.

More details on SQLite 3.9.0 can be found at SQLite.org.