jOOQ 3.19 supports explicit path joins, to-many path joins, and implicit join path correlation to greatly simplify your SQL queries

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.19 introduces new features including explicit path joins, to-many path joins, and implicit join path correlation.

jOOQ 3.19 offers many new and useful path based join features