... Improvements to the PRAGMA optimize command Enhancements to the date and time functions The ability to put "_" between digits in numeric literals for readability Added the json_pretty() function Improvements to the query planner, especially a new faster implementation for ... 

 ... Constant SQL functions are now factored out of inner loops, which can result in a significant speedup for queries that contain WHERE clause terms like "date>datetime('now','-2 days')". And various high-runner internal routines have been refactored for ... 

 ... A patchset blob may be used with up to date versions of all sqlite3changeset_xxx API functions except for sqlite3changeset_invert(), which returns SQLITE_CORRUPT if it is passed a patchset. Similarly, attempting to use a patchset blob with old versions of the ...