jOOQ
A Java library that generates a type-safe DSL from your database schema, so SQL — including MySQL- and MariaDB-specific syntax — can be written and checked by the compiler instead of assembled as strings.
jOOQ reads an existing database schema and generates Java classes representing its tables, columns, and keys, which are then used to build SQL queries through a fluent, type-safe API — the generated code fails to compile if a query no longer matches the schema. It’s developed by Data Geekery GmbH and maintained on GitHub at jOOQ/jOOQ.
The jOOQ Open Source Edition is free and dual-licensed under the Apache License 2.0 for use with open-source databases, including MySQL and MariaDB (alongside PostgreSQL, SQLite, and others) — with no license fee, payment, or renewal required for that edition. Separate commercial editions, priced per floating developer workstation per year, add support for proprietary databases such as Oracle and SQL Server plus some commercial-only features, but are not required to use jOOQ against MySQL or MariaDB.
Community feedback
This space is for grounded, evaluable experience — versions used, environments, what you measured or observed, and how it behaves alongside other software. General impressions without supporting detail may be removed. Sign in to write one; posts are tied to a verified identity, not anonymous.