jOOQ

jOOQ is a Java library for writing type safe SQL. It generates Java classes from your database, so the compiler can check your queries against the schema.

You build queries with a fluent Java API instead of raw strings, and the code generator creates classes for tables and columns. jOOQ supports stored procedures, row level security and schema overrides for multi-tenant setups. It also lets you hook into the SQL generation lifecycle for logging or transformation.

• Fluent Java API for SQL queries
• Code generation from database metadata
• Active record style CRUD
• Stored procedure calls inside queries
• SQL dialect transformation

Java developers and backend teams that prefer SQL over ORM mapping, especially for complex queries. Teams with an existing relational database may find the schema-first approach a good fit.

jOOQ can be downloaded from its website, and it has a pricing page for commercial editions. Check the licence for the edition you choose. The code generator needs a build step, so add it to your build tool before relying on it.