Simon Willison has released version 4.1.1 of sqlite-utils, a command-line tool for managing SQLite databases. The update addresses a specific failure mode where calling `table.transform()` would silently delete rows linked by foreign keys with destructive `ON DELETE` actions. Previously, the command could drop a table inside an open transaction while `PRAGMA foreign_keys` was enabled, triggering those actions without raising an error. The new code now raises a `TransactionError` in this scenario to prevent data loss.
This change matters because it enforces safer database operations during schema migrations. Developers working with relational constraints can now rely on explicit exceptions rather than unexpected data modifications. The release also improves documentation by linking CLI sections to their Python API equivalents and vice versa.
* Fixes issue #794 regarding foreign key transaction safety
* Enhances documentation cross-referencing per issue #791
* Prevents silent row deletion during destructive transforms