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 model API usage, traversal, and transformation
• Advanced SQL transformation features
• Procedural language support (procedures, functions, triggers, anonymous blocks)
• Spatial extension support
• Computed column support (server side and client side)
• Advanced SQL parser features
• Advanced diagnostics
• 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
      • Auto-inline bind values
      • Computed column activation
      • Computed column emulation
      • Dialect compatibility
      • Execute Logging SQL Exceptions
      • Readonly column behaviour
  • The model API
    • Traversal
    • Replacement
      • Pattern transformation Replacer
      • Table mapping Replacer
      • Listening Replacer
      • Decomposing Replacer
  • 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 TABLE
        • Computed columns
      • 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
    • Joined tables
      • JOIN hints
        • HASH JOIN
        • LOOP JOIN
        • MERGE JOIN
    • Temporal tables
  • Column expressions
    • Hidden columns
    • Readonly columns
    • Computed columns
    • Spatial functions
      • ST_Area
      • ST_AsText
      • ST_Boundary
      • ST_Centroid
      • ST_Difference
      • ST_Dimension
      • ST_Distance
      • ST_EndPoint
      • ST_ExteriorRing
      • ST_GeometryN
      • ST_GeometryType
      • ST_GeomFromText
      • ST_InteriorRingN
      • ST_Intersection
      • ST_Length
      • ST_NumGeometries
      • ST_NumInteriorRings
      • ST_NumPoints
      • ST_Perimeter
      • ST_PointN
      • ST_SRID
      • ST_StartPoint
      • ST_Transform
      • ST_Union
      • ST_X
      • ST_XMax
      • ST_XMin
      • ST_Y
      • ST_YMax
      • ST_YMin
      • ST_Z
      • ST_ZMax
      • ST_ZMin
    • Aggregate functions
      • COLLECT
  • Conditional expressions
    • Spatial predicates
      • ST_Contains
      • ST_Crosses
      • ST_Disjoint
      • ST_Equals
      • ST_Intersects
      • ST_IsClosed
      • ST_IsEmpty
      • ST_IsRing
      • ST_IsSimple
      • ST_IsValid
      • ST_Overlaps
      • ST_Touches
      • ST_Within
  • 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
      • GROUP BY <column index>
      • Inline CTE
      • Unnecessary arithmetic expressions
      • Pattern based transformation
    • Policies
      • Configuration
      • Implementation
      • Inheritance
      • Security considerations
• SQL execution
  • Diagnostics
    • Consecutive aggregation
    • Concatenation in predicates
    • Possibly wrong expressions
    • Trivial condition
    • Transform patterns
  • Logging with SQLExceptionLoggerListener
• Code generation
  • Advanced generator configuration
    • Database
      • Comments
      • Synthetic objects
        • Synthetic columns
        • Synthetic readonly columns
        • Synthetic readonly ROWIDs
        • Synthetic defaults
        • Synthetic enums
        • Synthetic unique keys
        • Synthetic foreign keys
        • Synthetic synonyms
      • Hidden columns
      • Readonly columns
      • Forced types
        • Client side computed columns
        • Audit columns
        • Hidden columns
        • Visibility Modifier (per forced type)
  • Generated object types
    • Generated triggers
  • Embeddable types
    • Overlapping embeddable types
    • Field replacement
    • Embedded keys
    • Embedded domains
• Reference
  • Commercial only features
  • Built-in data types
    • Spatial data types

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