---
title: "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 "
url: https://daily.dev/posts/jooq-3-20-released-with-clickhouse-databricks-and-much-more-duckdb-support-new-modules-oracle-ty-dbhwhtbc5
source_url: https://blog.jooq.org/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/
type: article
source: "JOOQ"
published: 2025-02-20T10:44:10.470Z
updated: 2025-02-20T10:44:38.389Z
tags: ["java", "backend", "sql", "kotlin", "scala"]
reading_time: 5
upvotes: 1
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# 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 

**[JOOQ](https://daily.dev/sources/jooq)** · 5 min read · 1 upvotes · 0 comments

## Summary

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.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://blog.jooq.org/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/>

## Similar posts on daily.dev

- [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments
- [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments
- [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments

---

Tags: [#java](https://daily.dev/tags/java), [#backend](https://daily.dev/tags/backend), [#sql](https://daily.dev/tags/sql), [#kotlin](https://daily.dev/tags/kotlin), [#scala](https://daily.dev/tags/scala)

[View this post on daily.dev](https://daily.dev/posts/jooq-3-20-released-with-clickhouse-databricks-and-much-more-duckdb-support-new-modules-oracle-ty-dbhwhtbc5)