SQLite 3.53.0 releases with significant accumulated improvements including ALTER TABLE constraint modifications, new JSON functions (json_array_insert), and major CLI mode enhancements via a new Query Results Formatter library.
# SQLite 3.53.0
Source: https://simonwillison.net/2026/Apr/11/sqlite/
11th April 2026 \- Link Blog
**SQLite 3\.53\.0 (https://sqlite.org/releaselog/3_53_0.html)**\(via (https://lobste.rs/s/sqsb24/sqlite_3_53_0)\) SQLite 3\.52\.0 was withdrawn so this is a pretty big release with a whole lot of accumulated user\-facing and internal improvements\. Some that stood out to me:
- `ALTER TABLE`can now add and remove`NOT NULL`and`CHECK`constraints \- I've previously used my ownsqlite\-utils transform\(\) method (https://sqlite-utils.datasette.io/en/stable/python-api.html#changing-not-null-status)for this\.
- Newjson\_array\_insert\(\) function (https://sqlite.org/json1.html#jarrayins)and its`jsonb`equivalent\.
- Significant improvements toCLI mode (https://sqlite.org/climode.html), including result formatting\.
The result formatting improvements come from a new library, theQuery Results Formatter (https://sqlite.org/src/file/ext/qrf)\. Ihad Claude Code (https://github.com/simonw/tools/pull/266)\(on my phone\) compile that to WebAssembly and buildthis playground interface (https://tools.simonwillison.net/sqlite-qrf)for trying that out\.
Posted11th April 2026 (https://simonwillison.net/2026/Apr/11/)at 7:56 pm
## Recent articles
- Changes in the system prompt between Claude Opus 4\.6 and 4\.7 (https://simonwillison.net/2026/Apr/18/opus-system-prompt/)\- 18th April 2026
- Join us at PyCon US 2026 in Long Beach \- we have new AI and security tracks this year (https://simonwillison.net/2026/Apr/17/pycon-us-2026/)\- 17th April 2026
- Qwen3\.6\-35B\-A3B on my laptop drew me a better pelican than Claude Opus 4\.7 (https://simonwillison.net/2026/Apr/16/qwen-beats-opus/)\- 16th April 2026
This is a**link post**by Simon Willison, posted on11th April 2026 (https://simonwillison.net/2026/Apr/11/)\.
sql112 (https://simonwillison.net/tags/sql/)sqlite459 (https://simonwillison.net/tags/sqlite/)
### Monthly briefing
Sponsor me for**$10/month**and get a curated email digest of the month's most important LLM developments\.
Pay me to send you less\!
Sponsor & subscribe (https://github.com/sponsors/simonw/)
sqlite-utils 4.1 introduces minor features including --code for Python code blocks, --type for column type overrides, and strict mode support, continuing its evolution as a SQLite CLI utility.
sqlite-utils 4.2 improves the transform() feature with support for complex schema definitions, new introspection properties, and other smaller changes, with contributions from multiple developers.