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 expressions
• SQL building : QueryParts : SQL transformation : Pattern based transformation : COUNT(*) scalar subquery comparison
• SQL building : QueryParts : SQL transformation : Pattern based transformation : COUNT(expr) scalar subquery comparison
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Empty scalar subquery
• 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 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 : 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 : Trigonometric functions
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Trim
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Trivial case abbreviations
• SQL building : QueryParts : SQL transformation : Pattern based transformation : Trivial predicates
• SQL execution : Diagnostics : Trivial condition
• Code generation : Advanced generator configuration : Database : Forced types : Client side computed columns
• Code generation : Running the code generator with Gradle