I'd be curious to hear more about the issues with joins, and dynamic conditionals. I've been working on a type provider lib for sql in kotlin[1].
The join problems I've seen are either the joined table has changed, or altered. The return type of a field may change.
The hard problem I encountered was doing things like json aggs, multiple joins, etc. I'm trying to address this by doing type safe aggregate/join functions.
Secondly is query compilation. Compiling the output record of advanced queries into an automatic data class.
The join problems I've seen are either the joined table has changed, or altered. The return type of a field may change.
The hard problem I encountered was doing things like json aggs, multiple joins, etc. I'm trying to address this by doing type safe aggregate/join functions. Secondly is query compilation. Compiling the output record of advanced queries into an automatic data class.
1: https://gitlab.com/AnimusDesign/kotlin-frm