- Add support for the FILTER clause on aggregate functions.
- Add support for the NULLS FIRST and NULLS LAST syntax in ORDER BY clauses.
- The index_info and index_xinfo pragmas are enhanced to provide information about the on-disk representation of WITHOUT ROWID tables.
- Add the sqlite3_drop_modules() interface, allowing applications to disable automatically loaded virtual tables that they do not need.
- Improvements to the .recover dot-command in the CLI so that it recovers more content from corrupt database files.
- Enhance the RBU extension to support indexes on expressions.
- Change the schema parser so that it will error out if any of the type, name, and tbl_name columns of the sqlite_master table have been corrupted and the database connection is not in writable_schema mode.
- The PRAGMA function_list, PRAGMA module_list, and PRAGMA pragma_list commands are now enabled in all builds by default. Disable them using -DSQLITE_OMIT_INTROSPECTION_PRAGMAS.
- Add the SQLITE_DBCONFIG_ENABLE_VIEW option for sqlite3_db_config().
- Added the TCL Interface config method in order to be able to disable SQLITE_DBCONFIG_ENABLE_VIEW as well as control other sqlite3_db_config() options from TCL.
- Added the SQLITE_DIRECTONLY flag for application-defined SQL functions to prevent those functions from being used inside triggers and views.
- The legacy SQLITE_ENABLE_STAT3 compile-time option is now a no-op.
Signed-off-by: Pierre-Yves <pyu@riseup.net>