Hacker News Reader

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

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.

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