Simon Willison: sqlite-utils 4.0rc3 — Compound Foreign Keys and Case-Insensitive Columns

Main idea

Simon Willison released the third release candidate for sqlite-utils 4.0 with two new additions: compound foreign key support (breaking change to the table.foreign_keys API) and case-insensitive column name handling following SQLite's own convention.

Context

Follows rc2 (July 5), which was largely written by Claude Fable 5 for ~$149. Willison continues his public experiment in AI-assisted open source maintenance, with rc3 expanding scope as AI helped resolve outstanding issues and PRs.

Why it matters

A concrete, documented case study of AI-assisted OSS maintenance at scale — with cost transparency (~$149 for an OSS release candidate). The compound foreign key API change (breaking) is why it was held for a major version.

Key points

• Compound foreign keys: introspecting and creating multi-column foreign keys — breaking change to table.foreign_keys API
• Case-insensitive column names: now follows SQLite's own convention
• rc2 development cost: ~$149 in AI API spend (Claude Fable 5 + GPT-5.5)
• rc3 further extended scope as AI helped resolve outstanding issues