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

• SQL building
  • The DSLContext API
    • Custom Settings
      • Auto-inline bind values
  • The model API
    • Replacement
      • Listening Replacer
      • Decomposing Replacer
  • SQL Statements (DML)
    • The SELECT statement
      • SELECT clause
        • Tables as SelectField
      • FOR XML clause
        • EXPLICIT mode
    • The INSERT statement
      • INSERT .. ON DUPLICATE KEY UPDATE .. EXCLUDED
      • INSERT .. ON DUPLICATE KEY UPDATE .. SET ALL TO EXCLUDED
      • INSERT .. ON CONFLICT .. EXCLUDED
      • INSERT .. ON CONFLICT .. SET ALL TO EXCLUDED
  • Column expressions
    • Numeric functions
      • ACOSH
      • ACOTH
      • ASINH
      • ATANH
    • Aggregate functions
      • BIT_NAND_AGG
      • BIT_NOR_AGG
      • BIT_XNOR_AGG
  • Data types
    • Extended data types
      • PostgreSQL CIDR type
      • PostgreSQL CITEXT type
      • PostgreSQL DATERANGE type
      • PostgreSQL INET type
      • PostgreSQL INT4RANGE type
      • PostgreSQL INT8RANGE type
      • PostgreSQL LTREE type
      • PostgreSQL NUMRANGE type
      • PostgreSQL TSRANGE type
      • PostgreSQL TSTZRANGE type
  • Dynamic SQL
    • Optional column expressions
  • QueryParts
    • SQL transformation
      • Pattern based transformation
        • AND to NOT IN
        • Arithmetic expressions
        • COUNT(*) scalar subquery comparison
        • COUNT(expr) scalar subquery comparison
        • Empty scalar subquery
        • Hyperbolic functions
        • Idempotent function repetition
        • Inverse hyperbolic functions
        • Logarithmic functions
        • Merge AND predicates
        • Merge BIT_NOT with BIT_NAND
        • Merge BIT_NOT with BIT_NOR
        • Merge BIT_NOT with BIT_XNOR
        • Merge IN predicates
        • Merge NOT with comparison predicates
        • Merge NOT with DISTINCT predicate
        • Merge OR predicates
        • Merge range predicates
        • Normalise associative operations
        • Normalise fields compared to values
        • Normalise IN list with single element to comparison
        • OR to IN
        • Repeated arithmetic negation
        • Repeated bitwise negation
        • Repeated NOT
        • Trigonometric functions
        • Trim
        • Trivial case abbreviations
        • Trivial predicates
  • SQL building in Kotlin
    • Kotlin MULTISET Collectors
    • Kotlin coroutine support
• SQL execution
  • Diagnostics
    • Trivial condition
• Code generation
  • Advanced generator configuration
    • Database
      • Synthetic objects
        • Synthetic columns
      • Forced types
        • Jackson converters
        • JAXB converters
        • Client side computed columns
        • Audit columns
        • Visibility Modifier (per forced type)
    • Generate
      • Text blocks