Have you used the jOOQ library in your projects?

jOOQ is a Java library that allows you to write SQL queries in the form of a typesafe DSL (domain-specific language). It generates Java code based on the database schema, making it easier to work with SQL and reducing the likelihood of errors.

Main advantages of jOOQ:

• Allows writing complex SQL queries directly in Java code.
• Provides type safety and autocomplete in IDE.
• Supports many SQL dialects.

Example of using jOOQ:

DSLContext create = DSL.using(configuration);

Result<Record> result = create.select()
    .from(BOOK)
    .where(BOOK.PUBLISHED_IN.eq(2023))
    .fetch();

for (Record r : result) {
    String title = r.getValue(BOOK.TITLE);
    System.out.println("Book title: " + title);
}

If projects require working with a database at the SQL level, jOOQ significantly simplifies writing and maintaining queries.