There have been many improvements to SQLite during 2022. Listed below or just a few of the bigger changes. See the change logs or the trunk timeline for a more complete list of enhancements and improvements.

New Features

• -> and ->> operators on JSON
• RIGHT and FULL OUTER JOIN
• Compiling to WASM
• The sqlite3_error_offset() C-language interface for better error reporting
• The recovery extension
• IS DISTINCT FROM and IS NOT DISTINCT FROM operators.
• unixepoch() and format() SQL functions

Enhancements

• 3.5% fewer CPU cycles used for the speedtest1.c benchmark
• Columnar output modes in the CLI
• Enhanced capabilities for virtual tables
• Numerous query planner enhancements, especially related to materialization of views, use of covering indexes, query flattening, and the use of Bloom filters.

Major Releases:

• 2022-02-22 Version 3.38.0
• 2022-06-25 Version 3.39.0
• 2022-11-16 Version 3.40.0