SQLite 3.53.0 Lands with Constraint Alterations and New JSON Functions

SQLite jumped from 3.51 straight to 3.53.0 after the 3.52.0 release was withdrawn, making this a particularly feature-dense update. Among the highlights: ALTER TABLE now supports adding and removing NOT NULL and CHECK constraints directly - functionality that previously required workarounds like Simon Willison’s sqlite-utils transform() method.

The release also introduces json_array_insert() with a corresponding jsonb variant, expanding SQLite’s JSON manipulation capabilities. The CLI received notable improvements to result formatting, powered by a new standalone Query Results Formatter library that Willison had compiled to WebAssembly using Claude Code to build an interactive playground.