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.