Simon Willison released sqlite-utils 4.0rc3, which introduces support for introspecting and creating compound foreign keys. This update also implements SQLite's convention for case-insensitive column names.
- Adds support for introspecting and creating compound foreign keys.
- Introduces a breaking change to the table.foreign_keys API to accommodate the new feature.
- Updates the library to follow SQLite's convention for case-insensitive column names across multiple areas.
The release was delayed as the changelog expanded while addressing issues and pull requests.