- sqlite-utils 4.0rc2 includes critical fixes, especially for transaction handling bugs like delete_where() not committing, which could cause data loss.
- The release was developed with Claude Fable over 37 prompts and 34 commits, costing an estimated $149.25.
- Key breaking changes include: db.execute() now auto-commits writes, db.query() executes SQL immediately and raises ValueError for non-row statements, and AssertionError replaced by ValueError for validation errors.
- Other fixes: table.upsert() raises PrimaryKeyRequired for missing primary keys, enable_wal()/disable_wal() raise TransactionError during open transactions, and the View class no longer has enable_fts().
- New features include db.begin(), db.commit(), db.rollback() methods for manual transaction control, and migrations now run inside transactions with rollback on failure.