jOOQ
jOOQ is the best way to write SQL in Java
What is jOOQ?
jOOQ is the best way to write SQL in Java
Overview of jOOQ
What it is
jOOQ is an internal DSL and source code generator that models the SQL language as a type safe Java API. It helps developers write better SQL by providing compile-time verification of SQL syntax and schema metadata.
Key features
- Source code generator that produces Java classes from database schemas - DSL API for type safe query construction and dynamic SQL - Dialect agnosticism for 30+ RDBMS - Support for
MULTISETandROWnested collections and records - Implicit path based joins and correlation to outer queries - Ad-hoc conversion for mapping structural record types to custom DTOs - Reactive support via R2DBC - Parser and translator for SQL - DAOs, data export/import, data type conversion, DDL/DML support, diagnostics, formatting, mapping, meta data API, mocking API, model API, multitenancy, pattern based transformation, plain SQL templating, policies, procedural logic API, readonly columns, Scala support, schema diff, SQL transformation, SQL translation, stored procedure support, transaction API, UpdatableRecords with optimistic locking
Use cases
- Building type safe database queries in Java applications - Generating Java code from existing database schemas - Writing dynamic SQL with compile-time safety - Nesting collections in SQL queries using
MULTISET - Translating SQL between different dialects - Implementing data access layers with DAOs and CRUD operations
Getting started
See the repository README for installation and quick start instructions.
License and pricing
The license is not stated in the provided metadata or README.
Based on the project's public README and repository metadata.