Anyone know a good sql library for sqlite? I am using sqldelight and the library is not well made. I remember using a c# library that would basically generate all the database stuff for me (and was LINQ compatible) without writing queries. sqldelight is a advanced abstraction layer which is workable but fairly annoying to deal with. Another library that is a good example is sequelize and represents what I am looking for

Does #exposed cover what you are looking for? (There's both a DSL API and a DAO API) If not, my apologies. I'm not familiar with either LINQ or sequlize, so I'm not sure what it is you are looking for.

my former colleague is a fan of JOOQ for DB-access. It's originally a Java program, but it supports Kotlin.

both those look viable thanks

jOOQ is way more mature, if that’s what you’re searching for Exposed is the cool kid, but it lacks official support at the moment (it will come, it has been announced)

with jOOQ i am wondering what parts of it are proprietary as I would only be using free version

If you use the classic databases you don’t have to pay, jOOQ is free for MySQL, PostgreSQL, SQLite, etc. https://www.jooq.org/download/