Starting with jOOQ 3.19, implicit path joins may skip unnecessary tables in the join tree, when no columns are referenced from those tables

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 a new feature for implicit path joins, allowing unnecessary tables to be skipped in the join tree. This optimization can improve query performance in certain scenarios.

Implicit path joins may now skip unnecessary tables in the join tree