SQLite 3.46.0 (64-bit)

What's new in this version:

Enhance PRAGMA optimize in multiple ways, to make it simpler to use:
- PRAGMA optimize automatically implements a temporary analysis limit to prevent excess runtime on large databases
- Added the new 0x10000 bitmask option to check for updates on all tables
- Automatically re-analyze tables that do not have sqlite_stat1 entries

Enhancements to the date and time functions:
- The strftime() SQL function now supports %G, %g, %U, and %V
- New modifiers 'ceiling' and 'floor' control the algorithm used to resolve ambiguous dates when shifting a date by an integer number of months and/or years
- The 'utc' and 'localtime' modifiers are now no-ops if SQLite knows that the time is already in UTC or in the localtime, respectively
- Add support for underscore ("_") characters between digits in numeric literals
- Add the json_pretty() SQL function

Query planner improvements:
- The "VALUES-as-coroutine" optimization enables INSERT statements with thousands of rows in the VALUES clause to parse and run in about half the time and using about half as much memory
- Allow the use of an index for queries like "SELECT count(DISTINCT col) FROM ...", even if the index records are not smaller than the table records
- Improved recognition of cases where the value of an SQL function is constant because all its arguments are constant
- Enhance the WHERE-clause push-down optimization so that it is able to push down WHERE clause terms containing uncorrelated subqueries
- Allocate additional memory from the heap for the SQL parser stack if that stack overflows, rather than reporting a "parser stack overflow" error

JSON changes:
- Allow ASCII control characters within JSON5 string literals
- Fix the -> and ->> operators so that when the right-hand side operand is a string that looks like an integer it is still treated as a string, because that is what PostgreSQL does
- Allow large hexadecimal literals to be used as the DEFAULT value to a table column