sqlite-utils 4.0rc3: Supports Compound Foreign Key Introspection & Creation
Decision Brief
What changedsqlite-utils 4.0rc3 introduces introspection and creation support for compound foreign keys, and follows SQLite's case-insensitive column name convention.
Why it mattersFor developers using sqlite-utils with complex relational databases, compound foreign key support eliminates workarounds for multi-column references, but the breaking change in table.foreign_keys requires code adjustments.
Who should careAI coding tool users
Affected stackClaudeOpenAI
Source confidenceMedium · Reliable media or first-hand reporting
sqlite-utils 4.0rc3, the third release candidate, is now available. The developer initially planned to release the stable version last weekend, but after merging numerous issues and PRs (some using Claude Fable 5 and GPT-5.5), the changelog kept expanding. The highlight is support for compound foreign keys introspection and creation. This requires a breaking change to the table.foreign_keys property, so it had to be included before 4.0 stable. Additionally, sqlite-utils now follows SQLite's case-insensitive column name convention, affecting many modules.
Summary basis: official / RSS sourceCompiled from the source scope noted above; the original remains authoritative.
Sources
- Simon Willison：Blog
Hands-on notes on LLM tools, local models, and practical AI engineering.
- Simon Willison：Blog