Alexander Ioffe
12/08/2025, 3:14 PM-> and ->> operators again! Use regular property dereferencing to access JSON properties of objects.
@SqlJsonValue @Serializable
data class ContactInfo(val email: String, val phone: String)
@Serializable
data class User(val id: Int, val name: String, val contacts: ContactInfo)
val emails = sql {
Table<User>().map { it.contacts.email }
}
// Postgres: SELECT contacts ->> 'email' FROM ...
// SQL Server: SELECT JSON_VALUE(contacts, '$.email') FROM ...
I wrote a blog post about this feature with runnable code samples. Read it here.
‣ R2DBC support
Works for Postgres, MySQL, SQL Server, and H2
Simpler SQL DSL:
• capture { … } is now just sql { … }, which is what it always wanted to be.
• CapturedFunction / CapturedDynamic were renamed to SqlFragment / SqlDynamic to match what they actually are.
• More built-in SQL helpers: common functions, IN (subquery) support, stringColumn.contains(string) and better null-handling.
• A batch of performance work (fewer unnecessary materializations) and a pile of bugfixes around error reporting and edge cases.
If you’ve been waiting for “the version where I can actually put this in production and not feel weird about it,” this is the one.Robert Jaros
12/08/2025, 3:16 PMAlexander Ioffe
12/08/2025, 3:17 PMRobert Jaros
12/08/2025, 3:21 PMAlexander Ioffe
12/08/2025, 3:21 PMStefan Oltmann
12/08/2025, 3:22 PMreally feels complete to meThe GitHub page is saying "JS-coming soon" 👀
Stefan Oltmann
12/08/2025, 3:25 PMAlexander Ioffe
12/08/2025, 3:27 PMThe GitHub page is saying "JS-coming soon" 👀People are actually using Kotlin JS with sqlite these days? I haven't prioritized it yet but maybe I should 😅
I like how exhaustive the GitHub readme is with all the samples. Very nice.Thanks! I've got a bunch of runnable code samples at exoquery.com/examples
Stefan Oltmann
12/08/2025, 3:30 PMAlexander Ioffe
12/08/2025, 3:32 PMStefan Oltmann
12/08/2025, 3:42 PMStefan Oltmann
12/08/2025, 3:45 PMAlexander Ioffe
12/08/2025, 3:47 PMStefan Oltmann
12/08/2025, 3:48 PMStefan Oltmann
12/08/2025, 3:48 PMStefan Oltmann
12/08/2025, 3:51 PMAlexander Ioffe
12/08/2025, 3:52 PMStefan Oltmann
12/08/2025, 3:53 PMStefan Oltmann
12/08/2025, 3:53 PMStefan Oltmann
12/08/2025, 3:55 PMAlexander Ioffe
12/08/2025, 3:56 PMStefan Oltmann
12/08/2025, 3:57 PMAlexander Ioffe
12/08/2025, 3:58 PMWinson Chiu
12/08/2025, 4:03 PMStefan Oltmann
12/08/2025, 4:05 PMRobert Jaros
12/08/2025, 4:15 PMio.r2dbc:r2dbc-postgresql driver in the readme. The quickstart chapter on the website uses the correct org.postgresql:r2dbc-postgresql driver.Alexander Ioffe
12/08/2025, 6:01 PMNorbert Kiesel
12/08/2025, 7:29 PMAlexander Ioffe
12/08/2025, 8:51 PMNorbert Kiesel
12/08/2025, 8:53 PMDaniel Zimmermann
12/09/2025, 12:35 PMAlexander Ioffe
12/10/2025, 7:49 AMNorbert Kiesel
12/10/2025, 7:50 AM