INSERT and UPDATE statements now always apply column affinity before computing CHECK constraints.

Added the iif() SQL function.

The ESCAPE clause of a LIKE operator now overrides wildcard characters, so that the behavior now matches what PostgreSQL does.

Added support for approximate ANALYZE using the PRAGMA analysis_limit command.

New extensions: bytecode virtual table, checksum VFS, UINT collation sequence.

New functions to better support of VFS shim implementations: sqlite3_create_filename(), sqlite3_free_filename(), and sqlite3_database_file_object().