sqlite-utils 4.0

sqlite-utils 4.0 introduces three major new features: database migrations for schema evolution, nested transaction support via db.atomic(), and support for compound foreign keys. The release includes minor backwards-incompatible fixes that prompted the major version number bump. Version 4.0 drops Python 3.8 support, switches upsert syntax to require SQLite 3.23.1 or later, and moves the tui command to a separate plugin.

Source: Simon Willison | 2026-07-07