sqldelight

Added

• [MySQL Dialect] MySQL support (by Jeff Gulbronson & Veyndan Stuart)
• [PostgreSQL Dialect] Experimental PostgreSQL support (by Veyndan Stuat)
• [HSQL Dialect] Experimental H2 support (by Marius Volkhart)
• [SQLite Dialect] SQLite FTS5 support (by Ben Asher & James Palawaga)
• [SQLite Dialect] Support alter table rename column (#1505 by Angus Holder)
• [IDE] IDE support for migration (.sqm) files
• [IDE] Add SQLDelight Live Templates that mimic built-in SQL Live Templates (#1154 by Veyndan Stuart)
• [IDE] Add new SqlDelight file action (#42 by Roman Zavarnitsyn)
• [Runtime] transactionWithReturn API for transactions that return results
• [Compiler] Syntax for grouping multiple SQL statements together in a .sq file
• [Compiler] Support generating schemas from migration files
• [Gradle Plugin] Add a task for outputting migration files as valid sql

Changed

• [Documentation] Overhaul of the documentation website (by Saket Narayan)
• [Gradle Plugin] Improve unsupported dialect error message (by Veyndan Stuart)
• [IDE] Dynamically change file icon based on dialect (by Veyndan Stuart)
• [JDBC Driver] Expose a JdbcDriver constructor off of javax.sql.DataSource (#1614)

Fixed

• [Compiler]Support Javadoc on tables and fix multiple javadoc in one file (#1224)
• [Compiler] Enable inserting a value for synthesized columns (#1351)
• [Compiler] Fix inconsistency in directory name sanitizing (by Zac Sweers)
• [Compiler] Synthesized columns should retain nullability across joins (#1656)
• [Compiler] Pin the delete statement on the delete keyword (#1643)
• [Compiler] Fix quoting (#1525 by Angus Holder)
• [Compiler] Fix the between operator to properly recurse into expressions (#1279)
• [Compiler] Give better error for missing table/column when creating an index (#1372)
• [Compiler] Enable using the outer querys projection in join constraints (#1346)
• [Native Driver] Make execute use transationPool (by Ben Asher)
• [JDBC Driver] Use the jdbc transaction APIs instead of sqlite (#1693)
• [IDE] Fix virtualFile references to always be the original file (#1782)
• [IDE] Use the correct throwable when reporting errors to bugsnag (#1262)
• [Paging Extension] Fix leaky DataSource (#1628)
• [Gradle Plugin] If the output db file already exists when generating a schema, delete it (#1645)
• [Gradle Plugin] Fail migration validation if there are gaps
• [Gradle Plugin] Explicitely use the file index we set (#1644)

An add-on for the 1.3.0 release which publishes the new RxJava 3 extensions at com.squareup.sqldelight:rxjava3-extensions.

• New: [Gradle] Dialect property to specify with sql dialect to compile against.
• New: [Compiler] #1009 Experimental support of the mysql dialect.
• New: [Compiler] #1436 Support of sqlite:3.24 dialect and upsert.
• New: [JDBC Driver] Split out JDBC driver from sqlite jvm driver.
• Fix: [Compiler] #1199 Support lambdas of any length.
• Fix: [Compiler] #1610 Fix the return type of avg() to be nullable.
• Fix: [IntelliJ] #1594 Fix path separator handling which broke Goto and Find Usages on Windows.

• New: [Runtime] Support for Windows (mingW), tvOS, watchOS, and macOS architectures.
• Fix: [Compiler] Return type of sum() should be nullable.
• Fix: [Paging] Pass Transacter into QueryDataSourceFactory to avoid race conditions.
• Fix: [IntelliJ Plugin] Don't search through dependencies when looking for a file's package name.
• Fix: [Gradle] #862 Change validator logs in Gradle to debug level.
• Enhancement: [Gradle] Convert GenerateSchemaTask to use Gradle worker.
• Note: sqldelight-runtime artifact renamed to runtime. ios-driver artifact renamed to native-driver

• Fix: [Gradle] Kotlin Native 1.3.60 support.
• Fix: [Gradle] #1287 Warning when syncing.
• Fix: [Compiler] #1469 SynetheticAccessor creation for query.
• Fix: [JVM Driver] Fixed memory leak.
• NOTE: The coroutine extension artifact requires kotlinx bintray maven repository be added to your buildscript.

• New: [Runtime] Stable Flow api.
• Fix: [Gradle] Kotlin Native 1.3.50 support.
• Fix: [Gradle] #1380 Clean build sometimes fails.
• Fix: [Gradle] #1348 Running verify tasks prints "Could not retrieve functions"
• Fix: [Compile] #1405 Can't build project if query contains FTS table joined.
• Fix: [Gradle] #1266 Sporadic gradle build failure while having multiple database modules

• New [Runtime] Experimental kotlin Flow api.
• Fix [Gradle] Kotlin/Native 1.3.40 compatibility.
• Fix [Gradle] #1243 Fix for usage of SQLDelight with Gradle configure on demand.
• Fix [Gradle] #1385 Fix for usage of SQLDelight with incremental annotataion processing.
• Fix [Gradle] Allow gradle tasks to cache.
• Fix [Gradle] #1274 Enable usage of sqldelight extension with kotlin dsl.
• Fix [Compiler] Unique ids are generated for each query deterministically.
• Fix [Compiler] Only notify listening queries when a transaction is complete.

• Gradle Metadata 1.0 release.

• New: [Runtime] #1267 Logging driver decorator.
• Fix: [Compiler] #1254 Split string literals which are longer than 2^16 characters.
• Fix: [Gradle] #1260 generated sources are recognized as iOS source in Multiplatform Project.
• Fix: [IDE] #1290 kotlin.KotlinNullPointerException in CopyAsSqliteAction.kt:43.
• Fix: [Gradle] #1268 Running linkDebugFrameworkIos* tasks fail in recent versions.

• Fix: [Gradle] Fix module dependency compilation for android projects.
• Fix: [Gradle] #1246 Set up api dependencies in afterEvaluate.
• Fix: [Compiler] Array types are properly printed.

• New: [Gradle] #502 Allow specifying schema module dependencies.
• Enhancement: [Compiler] #1111 Table errors are sorted before other errors.
• Fix: [Compiler] #1225 Return the correct type for REAL literals.
• Fix: [Compiler] #1218 docid propagates through triggers.

• Enhancement: [Runtime] #1195 Native Driver/Runtime Arm32.
• Enhancement: [Runtime] #1190 Expose the mapper from the Query type.

• Fix: [Gradle Plugin] Update to kotlin 1.3.20.
• Fix: [Runtime] Transactions no longer swallow exceptions.

• Enhancement: [Native Driver] Allow passing directory name to DatabaseConfiguration.
• Enhancement: [Compiler] #1173 Files without a package fail compilation.
• Fix: [IDE] Properly report IDE errors to Square.
• Fix: [IDE] #1162 Types in the same package show as error but work fine.
• Fix: [IDE] #1166 Renaming a table fails with NPE.
• Fix: [Compiler] #1167 Throws an exception when trying to parse complex SQL statements with UNION and SELECT.

• New: Complete overhaul of generated code, now in kotlin.
• New: RxJava2 extensions artifact.
• New: Android Paging extensions artifact.
• New: Kotlin Multiplatform support.
• New: Android, iOS and JVM SQLite driver artifacts.
• New: Transaction API.

• New: Compile-time validation of the columns used by insert, update, delete, index, and trigger statements.
• Fix: Don't crash IDE plugin on file move/create.

• New: Ctrl+/ (Cmd+/ on OSX) toggles comment of the selected line(s).
• New: Compile-time validation of the columns used by SQL queries.
• Fix: Support Windows paths in both the IDE and Gradle plugin.

• New: Added copy constructor to Marshal class.
• New: Update to Kotlin 1.0 final.
• Fix: Report 'sqldelight' folder structure problems in a non-failing way.
• Fix: Forbid columns named table_name. Their generated constant clashes with the table name constant.
• Fix: Ensure IDE plugin generates model classes immediately and regardless of whether .sq files were opened.
• Fix: Support Windows paths in both the IDE and Gradle plugin.