Download Latest Version Version 2.1.0 - 2025-05-16 source code.zip (5.6 MB)
Email in envelope

Get an email when there's a new version of SQLDelight

Home / 2.1.0
Name Modified Size InfoDownloads / Week
Parent folder
README.md 2025-05-16 8.1 kB
0
Version 2.1.0 - 2025-05-16 source code.tar.gz 2025-05-16 4.3 MB
0
Version 2.1.0 - 2025-05-16 source code.zip 2025-05-16 5.6 MB
5 5 weekly downloads
Totals: 3 Items   9.8 MB 5

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:

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

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

Added

  • [WASM Driver] Add support for wasmJs to web worker driver (#5534 by Ilya Gulya)
  • [PostgreSQL Dialect] Support PostgreSql UnNest Array to rows (#5673 by Griffio)
  • [PostgreSQL Dialect] PostgreSql TSRANGE/TSTZRANGE support (#5297 by Griffio)
  • [PostgreSQL Dialect] PostgreSql Right Full Join (#5086 by Griffio)
  • [PostgreSQL Dialect] Postrgesql extract from temporal types (#5273 by Griffio)
  • [PostgreSQL Dialect] PostgreSql array contains operators (#4933 by Griffio)
  • [PostgreSQL Dialect] PostgreSql drop constraint (#5288 by Griffio)
  • [PostgreSQL Dialect] Postgresql type casting (#5089 by Griffio)
  • [PostgreSQL Dialect] PostgreSql lateral join operator for subquery (#5122 by Griffio)
  • [PostgreSQL Dialect] Postgresql ILIKE operator (#5330 by Griffio)
  • [PostgreSQL Dialect] PostgreSql XML type (#5331 by Griffio)
  • [PostgreSQL Dialect] PostgreSql AT TIME ZONE (#5243 by Griffio)
  • [PostgreSQL Dialect] Support postgresql order by nulls (#5199 by Griffio)
  • [PostgreSQL Dialect] Add PostgreSQL current date/time function support (#5226 by Drew Dobson)
  • [PostgreSQL Dialect] PostgreSql Regex operators (#5137 by Griffio)
  • [PostgreSQL Dialect] add brin gist (#5059 by Griffio)
  • [MySQL Dialect] Support RENAME INDEX for MySql dialect (#5212 by Oren Kislev)
  • [JSON Extension] Add alias to json table function (#5372 by Griffio)

Changed

  • [Compiler] Generated query files return row counts for simple mutators (#4578 by Marius Volkhart)
  • [Native Driver] Update NativeSqlDatabase.kt to change readonly flag for DELETE, INSERT, and UPDATE statements (#5680 by Griffio)
  • [PostgreSQL Dialect] Change PgInterval to String (#5403 by Griffio)
  • [PostgreSQL Dialect] Support SqlDelight modules to implement PostgreSql extensions (#5677 by Griffio)

Fixed

  • [Compiler] fix: notify queries when executing group statements with result (#5006 by Vitor Hugo Schwaab)
  • [Compiler] Fix SqlDelightModule type resolver (#5625 by Griffio)
  • [Compiler] Fix 5501 insert object escaped column (#5503 by Griffio)
  • [Compiler] Compiler: Improve error message such that path links are clickable with the correct line & char position. (#5604 by Niklas Baudy)
  • [Compiler] Fix issue 5298: allow keywords to be used as table names
  • [Compiler] fix named executes and add test
  • [Compiler] Consider foreign key table constraints when sorting initialization statements (#5325 by Leon Linhart)
  • [Compiler] Align error underlines properly when tabs are involved (#5224 by Drew Dobson)
  • [JDBC Driver] Fix memory leak for connectionManager during end of transaction
  • [JDBC Driver] Run SQLite migrations inside transaction as mentioned in documentation (#5218 by Lukáš Moravec)
  • [JDBC Driver] Fix leaking connections after transaction commit / rollback (#5205 by Lukáš Moravec)
  • [Gradle Plugin] Execute DriverInitializer before GenerateSchemaTask (#5562 by Emeka Nwagu)
  • [Runtime] Fix crash in LogSqliteDriver when real driver is Async (#5723 by Eric Denman)
  • [Runtime] Fix StringBuilder capacity (#5192 by Jan Bína)
  • [PostgreSQL Dialect] PostgreSql create or replace view (#5407 by Griffio)
  • [PostgreSQL Dialect] Postgresql to_json (#5606 by Griffio)
  • [PostgreSQL Dialect] PostgreSql numeric resolver (#5399 by Griffio)
  • [PostgreSQL Dialect] sqlite windows function (#2799 by Griffio)
  • [PostgreSQL Dialect] PostgreSql SELECT DISTINCT ON (#5345 by Griffio)
  • [PostgreSQL Dialect] alter table add column if not exists (#5309 by Griffio)
  • [PostgreSQL Dialect] Postgresql async bind parameter (#5313 by Griffio)
  • [PostgreSQL Dialect] PostgreSql boolean literals (#5262 by Griffio)
  • [PostgreSQL Dialect] PostgreSql window functions (#5155 by Griffio)
  • [PostgreSQL Dialect] PostgreSql isNull isNotNull types (#5173 by Griffio)
  • [PostgreSQL Dialect] PostgreSql select distinct (#5172 by Griffio)
  • [Paging Extension] paging refresh initial load fix (#5615 by Eva)
  • [Paging Extension] Add MacOS native targets (#5324 by Vitor Hugo Schwaab)
  • [IntelliJ Plugin] K2 Support
Source: README.md, updated 2025-05-16