SQLite 3.42.0 (32-bit)

What's new in this version:

- Add the FTS5 secure-delete command. This option causes all forensic traces to be removed from the FTS5 inverted index when content is deleted
- Enhance the JSON SQL functions to support JSON5 extensions
- The SQLITE_CONFIG_LOG and SQLITE_CONFIG_PCACHE_HDRSZ calls to sqlite3_config() are now allowed to occur after sqlite3_initialize()
- New sqlite3_db_config() options: SQLITE_DBCONFIG_STMT_SCANSTATUS and SQLITE_DBCONFIG_REVERSE_SCANORDER
- Query planner improvements
- Enable the "count-of-view" optimization by default
- Avoid computing unused columns in subqueries
- Improvements to the push-down optimization
- Enhancements to the CLI
- Add the --unsafe-testing command-line option. Without this option, some dot-commands (ex: ".testctrl") are now disabled because those commands that are intended for testing only and can cause malfunctions misused
- Allow commands ".log on" and ".log off", even in --safe mode
- "--" as a command-line argument means all subsequent arguments that start with "-" are interpreted as normal non-option argument
- Magic parameters ":inf" and ":nan" bind to floating point literals Infinity and NaN, respectively
- The --utf8 command-line option omits all translation to or from MBCS on the Windows console for interactive sessions, and sets the console code page for UTF-8 I/O during such sessions. The --utf8 option is a no-op on all other platforms
- Add the ability for application-defined SQL functions to have the same name as join keywords: CROSS, FULL, INNER, LEFT, NATURAL, OUTER, or RIGHT
- Enhancements to PRAGMA integrity_check
- Detect and raise an error when a NaN value is stored in a NOT NULL column
- Improved error message output identifies the root page of a b-tree when an error is found within a b-tree
- Allow the session extension to be configured to capture changes from tables that lack an explicit ROWID
- Added the subsecond modifier to the date and time functions
- Negative values passed into sqlite3_sleep() are henceforth interpreted as 0
- The maximum recursion depth for JSON arrays and objects is lowered from 2000 to 1000
- Extended the built-in printf() function so the comma option now works with floating-point conversions in addition to integer conversions
- Miscellaneous bug fixes and performance optimizations