Highlighting that jOOQ emphasizes SQL syntax correctness
One of the coolest features of jOOQ consists of the fact that jOOQ doesn't allow us to write bad SQL syntax. If you aren't an SQL expert or simply have issues with SQL-specific syntax, then all you have to do is to let jOOQ guide you step by step.
Having a fluent API for chaining methods to obtain a SQL is cool, but having a fluent API that emphasizes SQL syntax correctness is the coolest. jOOQ knows exactly how the query parts fit the puzzle and will help you via your IDE.
For instance, let's assume that we accidentally wrote the following bad SQLs. Let's start with an SQL that misses the ON
clause:
ctx.select(EMPLOYEE.JOB_TITLE, EMPLOYEE.OFFICE_CODE, SALE.SALE_) .from(EMPLOYEE) .join(SALE) // "on" clause is missing here .fetch();
The IDE signals...