Hi! Does anyone recommend any ORM library for DB2 ...
# ktorm
mudasar187
11/29/2023, 1:22 PMHi! 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 PMIf your queries are complex, I wouldn't recommend using an ORM
h
hfhbd
11/29/2023, 1:27 PMI 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 PMit 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 PMWell, 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 PMand 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