Experimental features

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

To improve our development process and get more early adopter feedback, we've started publishing experimental functionality with our ordinary distribution. All such functionality is clearly documented as experimental either in the manual, and/or annotated with the @Experimental annotation in the API to make it clear that usage is done at the user's own risk as the API might still change in the future.

The below list of sections documents all the sections about experimental features in jOOQ:

• SQL building
  • The model API
    • Design
    • Traversal
    • Replacement
      • Listening Replacer
      • Decomposing Replacer
  • QueryParts
    • SQL transformation
      • Pattern based transformation
        • AND to NOT IN
        • Arithmetic comparisons
        • Arithmetic expressions
        • 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(*) scalar subquery comparison
        • COUNT(const)
        • COUNT(expr) scalar subquery comparison
        • DISTINCT FROM NULL
        • Empty scalar subquery
        • Flatten CASE
        • Flatten CASE abbreviations
        • Flatten DECODE
        • 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 CASE .. WHEN and ELSE clauses
        • Merge CASE .. WHEN clauses
        • 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
        • NOT AND
        • NOT OR
        • NULL ON NULL INPUT
        • OR to IN
        • Repeated arithmetic negation
        • Repeated bitwise negation
        • Repeated NOT
        • Simplify CASE abbreviations
        • Trigonometric functions
        • Trim
        • Trivial bitwise operations
        • Trivial CASE abbreviations
        • Trivial predicates
        • 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 execution
  • Diagnostics
    • Consecutive aggregation
    • Concatenation in predicates
    • Possibly wrong expressions
    • Trivial condition
    • Transform patterns
• Code generation
  • Advanced generator configuration
    • Database
      • Forced types
        • Client side computed columns