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 @griffi...

Codegen Changes

Generated insert/update/delete statements return the number of row changed now, meaning functions that relied on the codegen returning Unit will need to be updated like so:

fun doAnInsert() = db.someQueries.insert()

// changes to
fun doAnInsert() {
  db.someQueries.insert()
}

Added

• [WASM Driver] Add support for wasmJs to web worker driver...

Change Log

Added

• [PostgreSQL Dialect] Add PostgreSQL STRING_AGG function (#4950 by [André Danielsson][anddani])
• [PostgreSQL Dialect] Add SET statement to pg dialect (#4927 by [Bastien de Luca][de-luca])
• [PostgreSQL Dialect] Add PostgreSql alter column sequence parameters (#4916 by [Griffio][griffio])
• [PostgreSQL Dialect] Add postgresql alter column default support for insert s...

Added

• [Compiler] Add support multi-column-expr when doing a SELECT (#4453 by [Adriel Martinez][Adriel-M])
• [PostgreSQL Dialect] Add support for PostgreSQL CREATE INDEX CONCURRENTLY (#4531 by [Griffio][griffio])
• [PostgreSQL Dialect] Allow PostgreSQL CTEs auxiliary statements to reference each other (#4493 by [Griffio][griffio])
• [PostgreSQL Dialect] Add support for PostgreSQL types fo...

SQLDelight 2.0

Please see the detailed upgrading information for how to upgrade from SQLDelight 1.x to SQLDelight 2.0. The IntelliJ plugin needs to go through an approval before it lands on the marketplace inside of IntelliJ but can be downloaded and installed from disk below.

The below notes are all changes from SQLDelight 1.5....