sqlite-utils 4.2

This article announces the release of sqlite-utils 4.2, a Python command-line utility and library for manipulating SQLite databases. The release focuses on improvements to the table.transform() feature, which enables complex ALTER TABLE operations by creating a new table, copying data, and replacing the old one. Key enhancements include better preservation of edge-case schema definitions such as check constraints, unique constraints, and column comments. New introspection properties for check constraints are added, along with various smaller changes. Contributions from multiple developers are acknowledged. A note mentions that a crashing bug was fixed in version 4.2.1. This is relevant to IT/technology, specifically database tools and Python development.