What's new in version 3.20.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.20.0:

• SQL building
  • The DSLContext API
    • Custom Settings
      • Computed column activation
      • Dirty tracking
      • Fetching trimmed CHAR types
  • SQL Statements (DML)
    • The MERGE statement
      • WHEN NOT MATCHED AND ..
      • WHEN NOT MATCHED BY SOURCE
  • SQL Statements (DDL)
    • The CREATE statement
      • CREATE SEQUENCE
        • CREATE SEQUENCE .. AS
      • CREATE SYNONYM
        • CREATE OR REPLACE SYNONYM
    • The DROP statement
      • DROP SYNONYM
        • IF EXISTS
  • Column expressions
    • Hidden columns
    • String functions
      • BIN_TO_UUID
      • UUID_TO_BIN
    • Binary functions
      • BIT_LENGTH (binary)
      • CONCAT (binary, || operator)
      • LENGTH (binary)
      • LTRIM (binary)
      • MD5 (binary)
      • OCTET_LENGTH (binary)
      • OVERLAY (binary)
      • POSITION (binary)
      • RTRIM (binary)
      • SUBSTRING (binary)
      • TRIM (binary)
    • ARRAY functions
      • ARRAY_ALL_MATCH
      • ARRAY_ANY_MATCH
      • ARRAY_FILTER
      • ARRAY_MAP
      • ARRAY_NONE_MATCH
    • JSON functions
      • JSON_ARRAY_LENGTH
      • JSON_KEY_EXISTS
    • Spatial functions
      • ST_Boundary
      • ST_Dimension
      • ST_Perimeter
      • ST_Transform
      • ST_XMax
      • ST_XMin
      • ST_YMax
      • ST_YMin
      • ST_ZMax
      • ST_ZMin
    • Aggregate functions
      • LISTAGG (binary)
      • MAX_BY
      • MIN_BY
  • Conditional expressions
    • LIKE predicate (binary)
    • Quantified LIKE predicate (binary)
    • Spatial predicates
      • ST_IsRing
      • ST_IsSimple
      • ST_IsValid
  • Data types
    • Built-in data types
      • DECFLOAT (Decfloat)
• Code generation
  • Advanced generator configuration
    • Database
      • Synthetic objects
        • Synthetic defaults
        • Synthetic synonyms
      • Hidden columns
      • Forced types
        • Hidden columns
  • Generated object types
    • Generated synonyms