sqlite-utils 4.0, now with database schema migrations

This article announces the release of sqlite-utils 4.0, a major version update of the Python library for SQLite databases. It introduces three key features: database schema migrations using Python-defined migration files with a powerful table.transform() method, nested transactions via a new db.atomic() method, and support for compound foreign keys. The article explains how migrations track applied changes, provides code examples for creating and running migrations, and shows how to list pending and applied migrations. It also notes breaking changes and includes an upgrade guide. This is a technical software release announcement relevant to IT/technology, specifically database tools and Python development.