Commercial only features

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

The commercial jOOQ editions give access to drivers for certain commercial RDBMS as well as to commercial only features, which are not available in the jOOQ Open Source Edition. These features mostly involve:

• Advanced SQL transformation features
• Procedural language support (procedures, functions, triggers, anonymous blocks)

The below list of sections documents all the sections about commercial only features in jOOQ:

• SQL building
  • SQL Statements (DML)
    • The SELECT statement
      • CONNECT BY clause
  • Procedural statements
    • CONTINUE statement
    • EXECUTE statement
    • EXIT statement
    • FOR statement
    • GOTO statement
    • IF statement
    • Labels
    • LOOP statement
    • REPEAT statement
    • Variables
    • WHILE statement
  • Table expressions
    • Temporal tables
  • Column expressions
    • Aggregate functions
      • COLLECT
  • QueryParts
    • SQL transformation
      • ANSI JOIN to table lists
• Reference
  • Commercial only features

See also the Feature comparison for a high-level description.