Most serious data centric applications will quickly find DAOs or repositories insufficient. This is when jOOQ really shines with all its SQL support.

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's DAOs are a limited API useful only for very primitive CRUD tasks. They suffer from the same problem as repositories in that they are hardly ever enough for serious database interaction.

Like repositories, jOOQ's DAOs are only useful for very simple stuff