sqlite-utils 4.0rc3

The release of sqlite-utils 4.0rc3 introduces significant updates to the library, marking the final stages of preparation for the stable 4.0 version. The development process for this release was accelerated by utilizing AI tools to address a growing backlog of issues and pull requests.

The most notable addition is support for introspecting and creating compound foreign keys. This update required a subtle breaking change to the table.foreign_keys function, making it a necessary inclusion before the stable release can move forward.

Additionally, the library now aligns with SQLite’s standard conventions regarding case-insensitive column names. This change required adjustments across multiple areas of the codebase to ensure consistent behavior.

These updates are important because they improve the library's ability to handle complex database structures and ensure better compatibility with standard SQLite practices. By finalizing these features, the project moves closer to a stable release that offers more robust tools for database management and introspection.