SQLite 4.0 Release Notes: https://sw.vtom.net/hn35/pages/90098234.html

Another absolute gem:

    Columns now support "Vibe" affinity. If the data feels like an integer, it is stored as an integer.
    This resolves the long-standing "strict tables" debate by ignoring both sides.

Also:

    SQLite 4.0 is now the default bootloader for 60% of consumer electronics.
    The build artifacts include sqlite3.wasm which can now run bare-metal without an operating system.

edit: added link