2.2.1

Added

• [PostgreSQL Dialect] Fix Postgres numeric/integer/biginteger type mapping (#5994 by @griffio)
• [Compiler] Improve the compiler error message to include source file location when a CAST is required (#5979 by @griffio)
• [PostgreSQL Dialect] Add support for Postgres JSON operator path extraction (#5971 by @griffio)
• [SQLite Dialect] Add Sqlite 3.35 support for MATERIALIZED query planner hint using Common Table Expressions (#5961 by @griffio)
• [PostgreSQL Dialect] Add support for MATERIALIZED query planner hint using Common Table Expressions (#5961 by @griffio)
• [PostgreSQL Dialect] Add support for Postgres JSON Aggregate FILTER (#5957 by @griffio)
• [PostgreSQL Dialect] Add support for Postgres Enums (#5935 by @griffio)
• [PostgreSQL Dialect] Add limited support for Postgres Triggers (#5932 by @griffio)
• [PostgreSQL Dialect] Add predicate to check whether SQL expression can be parsed as JSON (#5843 by @griffio)
• [PostgreSQL Dialect] Add limited support for PostgreSql Comment On statement (#5808 by @griffio)
• [MySQL Dialect] Add support for index visibility options (#5785 by @orenkislev-faire)
• [PostgreSql Dialect] Add support for TSQUERY data type (#5779 by @griffio)
• [Gradle Plugin] Add support for version catalogs when adding modules (#5755 by @DRSchlaubi)

Changed

• In-development snapshots are now published to the Central Portal Snapshots repository at https://central.sonatype.com/repository/maven-snapshots/.
• [Compiler] Simplified default generated queries using constructor references (#5814 by @jonapoul)

Fixed

• [Compiler] Fix stack overflow when using View containing Common Table Expression (#5928 by @griffio)
• [Gradle Plugin] Fix crash when opening SqlDelight tool window to add "New Connection" (#5906 by @griffio)
• [IntelliJ Plugin] Avoid threading-related crash in the copy-to-sqlite gutter action (#5901 by @griffio)
• [IntelliJ Plugin] Fix for PostgreSql dialect when using schema statements CREATE INDEX and CREATE VIEW (#5772 by @griffio)
• [Compiler] Fix FTS stack overflow when referencing columns (#5896 by @griffio)
• [Compiler] Fix With Recursive stack overflow (#5892 by @griffio)
• [Compiler] Fix Notify for Insert|Update|Delete Returning statements (#5851 by @griffio)
• [Compiler] Fix async result type for transaction blocks returning Long (#5836 by @griffio)
• [Compiler] Optimize SQL parameter binding from O(n²) to O(n) complexity (#5898 by @chenf7)
• [SQLite Dialect] Fix Sqlite 3.18 missing functions (#5759 by @griffio)