A Super Secret Talk about Language Integrated Query
summary
Claims a working Kotlin solution called Exoquery that compiles captured queries into compile-time SQL via a compiler plugin, turning a messy set of “300 queries” with many variations into composable pieces. It uses Kotlinx serialization for parameter lifting and result mapping, targets Kotlin multiplatform (Android/iOS/native), emits compile errors for non‑translatable code, supports joins/nullability/upserts/returning/batch over JDBC, and demonstrates the system producing SQL at compile time and running successfully.
AI-written summary · about
chapters (14)
- 0:00Introduction to query pain
- 2:34The SQL abstraction crisis
- 7:11Limitations of existing Kotlin solutions
- 10:52Why compile-time metaprogramming?
- 14:19Introduction to ExoQuery
- 17:12Monadic foundations and LINQ
- 20:06Query flattening and performance
- 23:45Advanced composition and syntax
- 25:30Standard SQL operations
- 30:06Handling runtime parameters
- 33:47Multiplatform and native support
- 35:53CRUD actions and batching
- 40:53Future and commercial prospects
- 44:21Solving the initial problem
