What's new in version 3.19.0

Supported by ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The below list of sections documents all the sections about new features in jOOQ version 3.19.0:

• SQL building
  • The DSLContext API
    • Custom Settings
      • Dollar quoted string token
  • The model API
    • Replacement
      • Pattern transformation Replacer
      • Table mapping Replacer
  • SQL Statements (DML)
    • The SELECT statement
      • FROM clause
        • Implicit to-many path JOIN
        • Explicit path JOIN
        • Implicit path correlation
  • SQL Statements (DDL)
    • The ALTER statement
      • ALTER TYPE
        • ALTER TYPE IF EXISTS
    • The COMMENT statement
      • COMMENT ON MATERIALIZED VIEW
    • The CREATE statement
      • CREATE TYPE .. AS OBJECT
      • CREATE VIEW
        • MATERIALIZED
  • Table expressions
    • Joined tables
      • JOIN hints
        • HASH JOIN
        • LOOP JOIN
        • MERGE JOIN
  • Column expressions
    • Cast expressions (with TRY_CAST)
    • User-defined type attribute paths
  • Dynamic SQL
    • Optional tables
    • Optional join paths
  • QueryParts
    • Policies
      • Configuration
      • Implementation
      • Inheritance
      • Security considerations
• SQL execution
  • Logging system properties
• Code generation
  • Advanced generator configuration
    • Database
      • Inline database implementation
      • Synthetic objects
        • Synthetic enums
    • Generate
      • Covariant overrides
        • Overriding where()
      • Global object names
  • Generated object types
    • Generated triggers
  • Code generation execution
    • Running the code generator with Gradle
      • Multiple executions
      • Compiler dependency
      • Data change management
  • In-memory compilation of programmatic configuration