Condition building

Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition

With jOOQ, most conditional expressions are built from column expressions, calling various methods on them. For instance, to build a comparison predicate, you can write the following expression:

TITLE  = 'Animal Farm'

BOOK.TITLE.eq("Animal Farm")

Create conditions from the DSL

There are a few types of conditions, that can be created statically from the DSL. These are:

plain SQL conditions, that allow you to phrase your own SQL string conditional expression
The EXISTS predicate, a standalone predicate that creates a conditional expression
Constant TRUE and FALSE conditional expressions
Converting a BOOLEAN column to a condition