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

• SQL building
  • The DSLContext API
    • Custom Settings
      • Redacted column behaviour
  • SQL Statements (DDL)
    • The ALTER statement
      • ALTER TABLE
        • ALTER TABLE .. ALTER COLUMN .. SET GENERATED BY DEFAULT AS IDENTITY
        • ALTER TABLE .. ALTER COLUMN .. DROP IDENTITY
        • ALTER TABLE .. ALTER COLUMN .. SET GENERATED
        • ALTER TABLE .. ALTER COLUMN .. DROP GENERATED
        • ALTER TABLE .. CHANGE COLUMN
    • The COMMENT statement
      • COMMENT ON FUNCTION
      • COMMENT ON PROCEDURE
    • The CREATE statement
      • CREATE FUNCTION
        • COMMENT characteristic
      • CREATE PROCEDURE
        • COMMENT characteristic
      • CREATE TABLE
        • Local temporary tables
    • The DROP statement
      • DROP FUNCTION
        • DROP FUNCTION with signature
      • DROP PROCEDURE
        • DROP PROCEDURE with signature
      • DROP VIEW
        • CASCADE
  • Table expressions
    • TABLESAMPLE
  • Column expressions
    • Redacted columns
    • Numeric functions
      • ACOT
    • String functions
      • CONCAT_WS
    • ARRAY functions
      • ARRAY_CONTAINS
      • ARRAY_REVERSE
    • JSON functions
      • JSON_ARRAY from query
        • ABSENT ON NULL
        • NULL ON NULL
      • JSON_QUERY
    • Aggregate functions
      • APPROX_COUNT_DISTINCT
      • APPROX_PERCENTILE_CONT
      • APPROX_PERCENTILE_DISC
    • User-defined type constructor expressions
  • Data types
    • Converted data types
      • Custom data type Formatter
  • Dynamic SQL
    • Optional JSON entry expressions
  • QueryParts
    • SQL transformation
      • Pattern based transformation
        • COUNT(DISTINCT ..) with redundant args
• SQL execution
  • Diagnostics
    • Incomplete equi join
• Code generation
  • Advanced generator configuration
    • Database
      • Redacted columns
      • Forced types
        • Redacted columns
  • Embeddable types
    • Embedded columns (auto configuration)
• Reference
  • Security
    • Redacted columns