[peterisdirsa]

For Java, JOOQ is great and offers better type safety than this. Additionally, JOOQ generates data model classes from the DB schema.

[igalklebanov]

JOOQ is cool!

What do you mean by "better type safety"?

Kysely's ecosystem has 2 codegen libraries:

kysely-codegen introspects the database directly.

prisma-kysely generates types based on Prisma schemas.

[yashap]

There’s a popular sister project, kysely-codegen, that lets you do the same (generate types from the DB schema).