sqlite-utils 4.1.1

This article announces the release of sqlite-utils 4.1.1, a Python CLI utility and library for manipulating SQLite databases. The main fix addresses an edge case where table.transform() now raises a TransactionError if called during an open transaction with PRAGMA foreign_keys enabled and the table is referenced by foreign keys with destructive ON DELETE actions (CASCADE, SET NULL, SET DEFAULT). Previously, dropping the old table could silently delete or modify referencing rows. Additionally, the CLI and Python API documentation now cross-reference each other for easier navigation. This is a technical update relevant to software development and database management.