Is there any pure Kotlin Multiplatform DB/ORM libr...

# multiplatform

[Dennis L]

Is there any pure Kotlin Multiplatform DB/ORM libraries besides sqldelight? Something involving writing less SQL statements, I'm guessing it's the only one for now?

[kpgalligan]

That is the only one

[gildor]

Why do you need this?
I never understand problem that solved by some builder/dsl for SQL requests

[thevery]

sqldelight is not quite builder, but rather mapping and database provider, that is much more useful imo

[gildor]

@thevery Yes, I completely agree, I meant that sqldelight has much better approach imo that all those ORMs that try to hide SQL from you by horrible SQL request builder which is what Fhyber looking for

[thevery]

Lightweight builds like https://github.com/pushtorefresh/storio/blob/master/README.md are actually useful

[gildor]

But why?

[gildor]

I mean, yeah, it may be useful to pass arguments, better to just concatenate, but sqldelight also does this

[thevery]

Updating 3 fields in 10 fields entity without a builder is really painful, you have to write a lot of separate sql queries

[kpgalligan]

I think ORMs can be useful but I prefer sqldelight and would use that over Room, etc, if I was just doing Android (which seems an unlikely problem in the near future). “try to hide SQL from you by horrible SQL request builder” Anything that’s trying to hide SQL does kind of miss the point. However, in defense of ORMs, it was always the data mapping and relations that I found useful. The query builders are generally bad.