New dialects: jOOQ 3.20 ships with 2 new experimental dialects: ClickHouse in all editions, including the jOOQ Open Source Edition Databricks in the jOOQ Enterprise Edition ClickHouse is a fast-moving SQL dialect with a historic vendor-specific syntax that is gradually migrated to a more standards compliant alternative, which is why our support is still experimental.…

jOOQ is a Java library that provides a fluent API for building type-safe SQL queries and interacting with relational databases. With jOOQ, developers can write SQL queries in Java code, leveraging compile-time type checking and code generation to ensure correctness and maintainability. Developers can learn how to use jOOQ to simplify database interactions, reduce SQL boilerplate, and enhance productivity when working with SQL databases in Java applications.

JOOQ

jOOQ 3.20 introduces new experimental SQL dialects for ClickHouse and Databricks, along with improvements for DuckDB. New modules provide better integration with popular tools like Reactor, and support for Oracle type hierarchies has been added. Enhanced spatial, decfloat, and synonym support are now available, along with hidden columns and improved support for Kotlin 2 and Scala 3. Several code generation and DML join improvements are included, and the user manual now features an in-page search functionality.

jOOQ 3.20 released with ClickHouse, Databricks, and much more DuckDB support, new modules, Oracle type hierarchies, more spatial support, decfloat and synonym support, hidden columns, Scala 3, Kotlin 