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)
• Advanced SQL parser features
• Code generation extensions, e.g. for synthetic objects
• Advanced embeddable types

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

• SQL building
  • The DSLContext API
    • Custom Settings
      • Dialect compatibility
  • SQL Statements (DML)
    • The SELECT statement
      • CONNECT BY clause
      • FOR clause
  • SQL Statements (DDL)
    • The CREATE statement
      • CREATE FUNCTION
        • Scalar functions
        • CREATE OR REPLACE FUNCTION
        • SQL data access characteristics
        • DETERMINISTIC characteristic
        • ON NULL INPUT characteristic
      • CREATE PROCEDURE
        • CREATE OR REPLACE PROCEDURE
        • SQL data access characteristics
      • CREATE TRIGGER
        • Events
        • REFERENCING clause
        • STATEMENT vs ROW triggers
        • WHEN clause
    • The DROP statement
      • DROP FUNCTION
      • DROP PROCEDURE
      • DROP TRIGGER
  • Procedural statements
    • CALL statement
    • CONTINUE statement
    • EXECUTE statement
    • EXIT statement
    • FOR statement
    • GOTO statement
    • IF statement
    • Labels
    • LOOP statement
    • REPEAT statement
    • SIGNAL
    • Variables
    • WHILE statement
  • Table expressions
    • Temporal tables
  • Column expressions
    • Aggregate functions
      • COLLECT
  • SQL Parser
    • SQL Parser Listener
  • QueryParts
    • SQL transformation
      • ANSI JOIN to table lists
      • Table lists to ANSI JOIN
      • ROWNUM to LIMIT
      • QUALIFY to derived table
      • IN condition subquery with LIMIT to derived table
      • Unnecessary arithmetic expressions
• Code generation
  • Advanced generator configuration
    • Database
      • Comments
      • Synthetic objects
        • Synthetic unique keys
        • Synthetic foreign keys
  • Embeddable types
    • Overlapping embeddable types
    • Field replacement
    • Embedded keys
    • Embedded domains
• Reference
  • Commercial only features

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