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 MULTISET and ROW nested 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.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/jooqjooq.svg)](https://yunodb.com/tools/jooqjooq?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/jooqjooq?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/jooqjooq.svg" alt="Featured on YunoDB" height="20"></a>