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

• SQL building
  • The DSLContext API
    • SQL Dialect Category
    • Custom Settings
      • Computed column emulation
      • Diagnostics Connection
      • Diagnostics Logging
      • Execute Logging SQL Exceptions
      • Object qualification for columns
      • Return computed columns on store
      • Return DEFAULT columns on store
      • SEEK clause implementation
  • SQL Statements (DML)
    • The SELECT statement
      • GROUP BY clause
        • GROUP BY column index
  • SQL Statements (DDL)
    • The ALTER statement
      • ALTER VIEW
        • ALTER VIEW .. AS
  • Transactional statements
    • START TRANSACTION statement
    • COMMIT statement
    • ROLLBACK statement
    • SAVEPOINT statement
    • RELEASE SAVEPOINT statement
  • Table expressions
    • Aliased Tables
      • Aliased joined tables
    • WITH ORDINALITY
  • Column expressions
    • Bitwise functions
      • BIT_GET
      • BIT_SET
    • ARRAY functions
      • ARRAY_APPEND (|| operator)
      • ARRAY_CONCAT (|| operator)
      • ARRAY_OVERLAP
      • ARRAY_PREPEND (|| operator)
      • ARRAY_REMOVE
      • ARRAY_REPLACE
    • JSON functions
      • JSON_GET_ATTRIBUTE
      • JSON_GET_ATTRIBUTE_AS_TEXT
      • JSON_GET_ELEMENT
      • JSON_GET_ELEMENT_AS_TEXT
      • JSON_INSERT
      • JSON_KEYS
      • JSON_REMOVE
      • JSON_REPLACE
      • JSON_SET
  • Conditional expressions
    • XOR boolean operator
  • Data types
    • Built-in data types
      • YEAR (Year)
  • Plain SQL
    • Plain SQL raw templates
  • QueryParts
    • SQL transformation
      • GROUP BY <column index>
      • Inline CTE
      • Pattern based transformation
        • Arithmetic comparisons
        • BIT_GET function
        • BIT_SET function
        • CASE searched to CASE simple
        • CASE to CASE abbreviation
        • CASE with DISTINCT FROM to DECODE
        • CASE with ELSE NULL
        • COUNT(const)
        • DISTINCT FROM NULL
        • Flatten CASE
        • Flatten CASE abbreviations
        • Flatten DECODE
        • Merge CASE .. WHEN and ELSE clauses
        • Merge CASE .. WHEN clauses
        • NOT AND
        • NOT OR
        • NULL ON NULL INPUT
        • Simplify CASE abbreviations
        • Trivial bitwise operations
        • Unnecessary DISTINCT
        • Unnecessary EXISTS subquery clauses
        • Unnecessary GROUP BY expressions
        • Unnecessary INNER JOIN
        • Unnecessary ORDER BY expressions
        • Unnecessary scalar subquery
        • Unreachable CASE clauses
        • Unreachable DECODE clauses
  • SQL building in Kotlin
    • Kotlin ResultQuery Collectors
    • Kotlin JSON access
• SQL execution
  • Fetching
    • Context Converter
  • Diagnostics
    • Consecutive aggregation
    • Concatenation in predicates
    • Possibly wrong expressions
    • Transform patterns
  • Logging with SQLExceptionLoggerListener
• Code generation
  • Advanced generator configuration
    • Database
      • Forced types
        • Auto converters