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

• SQL building
  • The DSLContext API
    • Custom Settings
      • Dialect compatibility
      • GROUP_CONCAT Configuration
      • Meta system objects
  • 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 TRIGGER
        • Events
        • REFERENCING clause
        • STATEMENT vs ROW triggers
        • WHEN clause
    • The DROP statement
      • DROP FUNCTION
        • IF EXISTS
      • DROP PROCEDURE
        • IF EXISTS
      • DROP TRIGGER
        • IF EXISTS
  • Procedural statements
    • CALL statement
    • SIGNAL
  • Column expressions
    • Numeric functions
      • LOG10
      • SQUARE
    • String functions
      • CHR
      • DIGITS
      • SPLIT_PART
      • SUBSTRING_INDEX
      • TO_HEX
      • UUID
    • ARRAY functions
      • ARRAY constructor from subquery
    • XML functions
      • XMLSERIALIZE
    • System functions
      • CURRENT_CATALOG
    • Aggregate functions
      • ANY_VALUE
      • MULTISET_AGG
    • ARRAY value constructor
    • MULTISET value constructor
    • Nested records
  • Data types
    • Extended data types
      • PostgreSQL HSTORE type
  • SQL Parser
    • SQL Parser Listener
  • QueryParts
    • SQL transformation
      • QUALIFY to derived table
      • IN condition subquery with LIMIT to derived table
  • SQL building in Kotlin
    • Kotlin ARRAY access
• SQL execution
  • Fetching
    • Ad-hoc Converter
• Code generation
  • Advanced generator configuration
    • Database
      • Comments
    • Generate
      • Visibility Modifier
  • Code generation extensions
    • PostgreSQL extensions
• Coming from JPA
  • @OneToOne or @ManyToOne
  • @OneToMany or @ManyToMany