https://kotlinlang.org logo
#ktor
Title
# ktor
m

mudasar187

11/29/2023, 1:22 PM
Hi! Does anyone recommend any ORM library for DB2 databases? We have some old legeacy systems with db2 databases with very complex queries.
j

Johann Pardanaud

11/29/2023, 1:26 PM
If your queries are complex, I wouldn't recommend using an ORM
h

hfhbd

11/29/2023, 1:27 PM
I wrote an experimental DB2 dialect for sqldelight. I am happy for any feedback to improve it! https://github.com/hfhbd/sqldelight-db2-dialect
neat 1
m

mudasar187

11/29/2023, 1:29 PM
it does not need to be ORM actually, just some .. maybe library with extensions methods which help me writing complex queries easier 🙂 somehting like this maybe -> https://github.com/AlessioCoser/jako
h

hfhbd

11/29/2023, 1:30 PM
Well, sqldelight does it the other way, you write traditional sql queries and sqldelight compiles them and adds type safe Kotlin queries: https://cashapp.github.io/sqldelight/
💯 1
j

Johann Pardanaud

11/29/2023, 1:32 PM
and this can be really useful for your use case, you won't need to rewrite your SQL queries with whatever library, you just copy/paste them and you get a method ready to use
2 Views