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

• SQL building
  • The DSLContext API
    • Custom Settings
      • Batch size
      • Implicit join type
  • SQL Statements (DML)
    • The SELECT statement
      • FOR XML clause
        • AUTO mode
        • PATH mode
        • RAW mode
        • ROOT directive
        • ELEMENTS directive
      • FOR JSON clause
        • AUTO mode
        • PATH mode
        • ROOT directive
        • INCLUDE_NULL_VALUES directive
        • WITHOUT_ARRAY_WRAPPER directive
    • The MERGE statement
      • WHEN MATCHED AND ..
  • SQL Statements (DDL)
    • The ALTER statement
      • ALTER DATABASE
        • ALTER DATABASE .. RENAME
        • ALTER DATABASE IF EXISTS
      • ALTER DOMAIN
        • ALTER DOMAIN .. RENAME
        • ALTER DOMAIN .. SET DEFAULT
        • ALTER DOMAIN .. DROP DEFAULT
        • ALTER DOMAIN .. SET NOT NULL
        • ALTER DOMAIN .. DROP NOT NULL
        • ALTER DOMAIN .. ADD CONSTRAINT
        • ALTER DOMAIN .. RENAME CONSTRAINT
        • ALTER DOMAIN .. RENAME CONSTRAINT IF EXISTS
        • ALTER DOMAIN .. DROP CONSTRAINT
        • ALTER DOMAIN .. DROP CONSTRAINT IF EXISTS
        • ALTER DOMAIN IF EXISTS
    • The CREATE statement
      • CREATE DATABASE
      • CREATE DOMAIN
    • The DROP statement
      • DROP DATABASE
        • IF EXISTS
      • DROP DOMAIN
        • IF EXISTS
  • Table expressions
    • JSON_TABLE
    • XMLTABLE
  • Column expressions
    • String functions
      • OVERLAY
      • REGEXP_REPLACE
      • TO_CHAR
    • ARRAY functions
      • ARRAY_GET
      • CARDINALITY
    • JSON functions
      • JSON_VALUE
    • XML functions
      • XMLATTRIBUTES
      • XMLCOMMENT
      • XMLCONCAT
      • XMLDOCUMENT
      • XMLELEMENT
      • XMLFOREST
      • XMLPARSE
      • XMLPI
      • XMLQUERY
    • Aggregate functions
      • JSON_ARRAYAGG
        • ABSENT ON NULL
        • NULL ON NULL
      • JSON_OBJECTAGG
        • ABSENT ON NULL
        • NULL ON NULL
      • XMLAGG
  • Conditional expressions
    • DOCUMENT predicate
    • JSON_EXISTS predicate
    • XMLEXISTS predicate
  • Data types
    • Built-in data types
      • XML (XML)
    • Domain data types
  • QueryParts
    • SQL transformation
      • Table lists to ANSI JOIN
      • ROWNUM to LIMIT
      • Unnecessary arithmetic expressions
  • SQL building in Kotlin
    • Kotlin BOOLEAN value expressions
• SQL execution
  • Fetching
    • ConverterProvider
  • CRUD with UpdatableRecords
    • Simple CRUD
      • CRUD: Merge
  • Batched Connection
• Code generation
  • Advanced generator configuration
    • Database
      • Synthetic objects
        • Synthetic identities
        • Synthetic primary keys
        • Synthetic unique keys
        • Synthetic foreign keys
      • Forced types
        • Lambda converters
    • Generate
      • Serial Version UID
  • Generated object types
    • Generated domains
  • Embeddable types
    • Configuration
    • Overlapping embeddable types
    • Field replacement
    • Embedded keys
    • Embedded domains
  • Alternative output languages
    • KotlinGenerator
    • ScalaGenerator