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
• SQL building : The model API : Traversal
• SQL building : The model API : Replacement
• SQL building : The model API : Replacement : Listening Replacer
• SQL building : The model API : Replacement : Decomposing Replacer
• SQL building : QueryParts : SQL transformation : Pattern based transformation
• SQL building : QueryParts : SQL transformation : Pattern based transformation : AND to NOT IN
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Arithmetic comparisons
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Arithmetic expressions
• SQL building : QueryParts : SQL transformation : Pattern based transformation : BIT_GET function
• SQL building : QueryParts : SQL transformation : Pattern based transformation : BIT_SET function
• SQL building : QueryParts : SQL transformation : Pattern based transformation : CASE searched to CASE simple
• SQL building : QueryParts : SQL transformation : Pattern based transformation : CASE to CASE abbreviation
• SQL building : QueryParts : SQL transformation : Pattern based transformation : CASE with DISTINCT FROM to DECODE
• SQL building : QueryParts : SQL transformation : Pattern based transformation : CASE with ELSE NULL
• SQL building : QueryParts : SQL transformation : Pattern based transformation : COUNT(*) scalar subquery comparison
• SQL building : QueryParts : SQL transformation : Pattern based transformation : COUNT(const)
• SQL building : QueryParts : SQL transformation : Pattern based transformation : COUNT(expr) scalar subquery comparison
• SQL building : QueryParts : SQL transformation : Pattern based transformation : DISTINCT FROM NULL
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Empty scalar subquery
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Flatten CASE
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Flatten CASE abbreviations
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Flatten DECODE
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Hyperbolic functions
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Idempotent function repetition
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Inverse hyperbolic functions
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Logarithmic functions
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Merge AND predicates
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Merge BIT_NOT with BIT_NAND
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Merge BIT_NOT with BIT_NOR
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Merge BIT_NOT with BIT_XNOR
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Merge CASE .. WHEN and ELSE clauses
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Merge CASE .. WHEN clauses
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Merge IN predicates
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Merge NOT with comparison predicates
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Merge NOT with DISTINCT predicate
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Merge OR predicates
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Merge range predicates
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Normalise associative operations
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Normalise fields compared to values
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Normalise IN list with single element to comparison
• SQL building : QueryParts : SQL transformation : Pattern based transformation : NOT AND
• SQL building : QueryParts : SQL transformation : Pattern based transformation : NOT OR
• SQL building : QueryParts : SQL transformation : Pattern based transformation : NULL ON NULL INPUT
• SQL building : QueryParts : SQL transformation : Pattern based transformation : OR to IN
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Repeated arithmetic negation
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Repeated bitwise negation
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Repeated NOT
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Simplify CASE abbreviations
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Trigonometric functions
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Trim
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Trivial bitwise operations
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Trivial CASE abbreviations
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Trivial predicates
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Unnecessary DISTINCT
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Unnecessary EXISTS subquery clauses
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Unnecessary GROUP BY expressions
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Unnecessary INNER JOIN
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Unnecessary ORDER BY expressions
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Unnecessary scalar subquery
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Unreachable CASE clauses
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Unreachable DECODE clauses
• SQL execution : Diagnostics : Consecutive aggregation
• SQL execution : Diagnostics : Concatenation in predicates
• SQL execution : Diagnostics : Possibly wrong expressions
• SQL execution : Diagnostics : Trivial condition
• SQL execution : Diagnostics : Transform patterns
• Code generation : Advanced generator configuration : Database : Forced types : Client side computed columns
• Code generation : Running the code generator with Gradle