Module org.jooq
Package org.jooq
package org.jooq
This package contains jOOQ's public API.
This package mostly contains interfaces that are implemented by the
org.jooq.impl package. These interfaces are constructed mostly
through the DSL and DSLContext
classes, which hide implementation facts from the public API.
-
ClassDescriptionThe step in the specification of aggregate functions where the SQL:2003 standard
FILTER clausecan be added.An aggregate function.Allow a set ofSQLDialectto be supported by any jOOQ statement in the scope of this annotation.This annotation allowsAllow.PlainSQLAPI usage within the scope of where it is placed.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theALTER DATABASEstatement.A step in the construction of theALTER DOMAINstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theALTER DOMAINstatement.A step in the construction of theALTER DOMAINstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theALTER INDEXstatement.A step in the construction of theALTER INDEXstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theALTER SCHEMAstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.AlterSequenceFlagsStep<T extends Number>A step in the construction of theALTER SEQUENCEstatement.AlterSequenceStep<T extends Number>A step in the construction of theALTER SEQUENCEstatement.The step in theALTER TABLEDSL used toADDcolumns.The step in theALTER TABLEDSL used toALTERconstraints.The step in theALTER TABLEDSL used toALTERcolumns.The step in theALTER TABLEDSL used toDROPcolumns or constraints.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.The step in theALTER TABLEDSL used toRENAMEcolumns.The step in theALTER TABLEDSL used toRENAMEconstraints.The step in theALTER TABLEDSL used toRENAMEindexes.The step in theALTER TABLEstatement where the action can be decided.The step in theALTER TABLE … ADD CONSTRAINTstatement where an optional index can be specified to enforce the constraint.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theALTER TYPEstatement.A step in the construction of theALTER TYPEstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theALTER VIEWstatement.The SQL standardARRAY_AGG()function.ArrayRecord<E>A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally providing some convenience methods.A "record" that encapsulates an Oracle-style associative array, additionally providing some convenience methods.An unqualified asterisk.An object in jOOQ that can have an underlyingConfigurationattached or detached.A type that is bothAttachableand aQueryPart.An SPI to provide audit fields.The type of the audit info produced by anAuditGenerator.A wrapper for a JDBC batch operation.This type is used for theBatch's DSL API.An operation that can run code and statements, buffering all consecutive and identical SQL strings in aBatchedPreparedStatement, delaying their execution.An operation that can run code and statements, buffering all consecutive and identical SQL strings in aBatchedPreparedStatement, delaying their execution.An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep1<T1>An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep2<T1,T2> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep3<T1,T2, T3> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep4<T1,T2, T3, T4> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep5<T1,T2, T3, T4, T5> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep6<T1,T2, T3, T4, T5, T6> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep7<T1,T2, T3, T4, T5, T6, T7> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep8<T1,T2, T3, T4, T5, T6, T7, T8> An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStep9<T1,T2, T3, T4, T5, T6, T7, T8, T9> An intermediate DSL type for the construction of aBETWEENpredicate.An intermediate DSL type for the construction of aBETWEENpredicate.BetweenAndStepR<R extends Record>An intermediate DSL type for the construction of aBETWEENpredicate.The bind context is used for bindingQueryPart's and their contained values to aPreparedStatement's bind variables.Binding<T,U> An SPI (Service Provider Interface) that exposes all low-level interactions with JDBC bind variables.A container type forBinding.get(BindingGetResultSetContext)arguments.A container type forBinding.get(BindingGetSQLInputContext)arguments.A container type forBinding.get(BindingGetStatementContext)arguments.A container type forBinding.register(BindingRegisterContext)arguments.A container type forBinding.set(BindingSetSQLOutputContext)arguments.A container type forBinding.set(BindingSetStatementContext)arguments.A container type forBinding.sql(BindingSQLContext)arguments.A procedural block.The parameter object passed to theCacheProvider.provide(CacheContext)method.A provider for cache implementations to replace the default.A step in the construction of theCALLstatement.The SQL case statement.The final step in creating a case statement of the typeAn intermediary step in creating a case statement of the typeCaseWhenStep<V,T> The final step in creating a case statement of the typeA catalog.A character set.A CSV formatting type, which can be used to configure chart exports.The chart output format.A check constraint.Simple version of the JSR 305 annotation that allows for inspecting jOOQ code and detect accidentally omitted calls toQuery.execute()and the likes in IntelliJ.Deprecated, for removal: This API element is subject to removal in a future version.- 3.11.0 - [#7258] - This part of theVisitListenerSPI is deprecated.A resourcefulDSLContextthat should be closed in a try-with-resources statement.AQuerythat holds a reference to the underlyingPreparedStatementwithout closing it, for reuse.CloseableResultQuery<R extends Record>AResultQuerythat holds a reference to the underlyingPreparedStatementwithout closing it, for reuse.A collation.A common base type forCommentand other, potential future types where DSL API accepts all types alike.A comment.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theCOMMENT ON TABLEstatement.A commit in a version control system.An SPI that allows for providing a graph of versions.A (sub) set of commits.CommonTableExpression<R extends Record>A common table expression.A comparator to be used in conditions to form comparison predicates.A condition or predicate.Deprecated, for removal: This API element is subject to removal in a future version.- 2.6.0 [#1881] - This type will be removed from the public API, soon.AConfigurationconfigures aDSLContext, providing it with information for query rendering and execution.An operation that can run code and statements against a provided JDBCConnection.A connection lifecycle handler API.An operation that can run code and statements against a provided JDBCConnection.Some publicly available constants used in jOOQA DDL constraint.The step in theConstraintconstruction DSL API that allows for addingENFORCEDandNOT ENFORCEDclauses.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.The step in theConstraintconstruction DSL API that allows for addingON DELETEandON UPDATEclauses.The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep3<T1,T2, T3> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep4<T1,T2, T3, T4> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep5<T1,T2, T3, T4, T5> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep6<T1,T2, T3, T4, T5, T6> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep7<T1,T2, T3, T4, T5, T6, T7> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep8<T1,T2, T3, T4, T5, T6, T7, T8> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.ConstraintForeignKeyReferencesStep9<T1,T2, T3, T4, T5, T6, T7, T8, T9> The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.The step in theConstraintconstruction DSL API that allows for matching aFOREIGN KEYclause with aREFERENCESclause.The step in theConstraintconstruction DSL API that allows for specifying the constraint type.TheFile.type().A context type that is used for rendering SQL or for binding.AnFunctionalInterfacethat wraps transactional code.AnFunctionalInterfacethat wraps transactional code.A step in the construction of anCONTINUEstatement where aWHENclause can be added.Converter<T,U> AConverterfor data types.Converters<T,U> A chain of converters.An unknown type that is used when users do not provide any explicit user typeClassreference e.g.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theCREATE DOMAINstatement.A step in the construction of theCREATE DOMAINstatement.A step in the construction of theCREATE DOMAINstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theCREATE FUNCTIONstatement.A step in the construction of theCREATE FUNCTIONstatement.A step in the construction of theCREATE FUNCTIONstatement.A step in the construction of theCREATE FUNCTIONstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theCREATE INDEXstatement.A step in the construction of theCREATE INDEXstatement.A step in the construction of theCREATE INDEXstatement.A step in the construction of theCREATE PROCEDUREstatement.A step in the construction of theCREATE PROCEDUREstatement.A step in the construction of theCREATE PROCEDUREstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theCREATE SEQUENCEstatement.A step in the construction of theCREATE TABLEstatement.A step in the construction of theCREATE TABLEstatement.A step in the construction of theCREATE TABLEstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theCREATE TABLEstatement.A step in the construction of theCREATE TABLEstatement.A step in the construction of theCREATE TABLEstatement.A step in the construction of theCREATE TRIGGERstatement.A step in the construction of theCREATE TRIGGERstatement.A step in the construction of theCREATE TRIGGERstatement.A step in the construction of theCREATE TRIGGERstatement.A step in the construction of theCREATE TRIGGERstatement.A step in the construction of theCREATE TRIGGERstatement.A step in the construction of theCREATE TRIGGERstatement.A step in the construction of theCREATE TRIGGERstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.AQuerythat can create types.CreateViewAsStep<R extends Record>AQuerythat can create views.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A CSV formatting type, which can be used to configure CSV imports / exports.When to apply the quoteCursors allow for lazy, sequential access to an underlying JDBCResultSet.A generic DAO interface for a pojo and a primary key type.DataType<T>A common interface to all dialect-specific data types.A date part can be used with SQL functions such as extract().A configuration type for use with the variousMeta.ddl()methods.A marker interface for all DDL queries.Declaration<T>A local variable declaration.ADELETEstatement.DeleteConditionStep<R extends Record>This type is used for theDelete's DSL API.DeleteFinalStep<R extends Record>Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.DeleteLimitStep<R extends Record>This type is used for theDelete's DSL API.DeleteOrderByStep<R extends Record>This type is used for theDelete's DSL API.DeleteQuery<R extends Record>ADELETEstatement (model API).DeleteResultStep<R extends Record>This type is used for theDelete's DSL API.DeleteReturningStep<R extends Record>This type is used for theDelete's DSL API.DeleteUsingStep<R extends Record>This type is used for theDelete's DSL API.DeleteWhereStep<R extends Record>This type is used for theDelete's DSL API.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A derived column list.A parameter object that is passed toDiagnosticsListenermethods.A diagnostics listener.A provider forTransactionListenerinstances.A command line interface to the Parser API, which works in a similar way as https://www.jooq.org/translate.An intermediate type for the construction of a relational division.An intermediate type for the construction of a relational divisionAn intermediate type for the construction of a relational divisionDomain<T>The meta model of a SQLDOMAINDeprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theDROP DOMAINstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theDROP INDEXstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theDROP INDEXstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theDROP SCHEMAstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theDROP TABLEstatement.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.AQuerythat can drop types.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A contextual DSL providing "attached" implementations to theorg.jooqinterfaces.EmbeddableRecord<R extends EmbeddableRecord<R>>An embeddable record.A SQL enum type.A context object forQueryexecution passed to registeredExecuteListener's.An event handler implementingExecuteListenerevents.A provider forExecuteListenerinstances.AScopethat knows itsExecuteContext.The type of database interaction that is being executed with this context.TheExecutorProviderSPI can be used to provide jOOQ with custom asynchronous execution behaviour.A step in the construction of anEXITstatement where aWHENclause can be added.Results of anDSLContext.explain(Query)call.AConditionthat always yieldsfalse.Field<T>A column expression.An object that can behave like a field (a field-like object).Deprecated.- 3.17.0 - [#13005] - UseTableElementinstead.A source of migration content.A utility class that can traverse a directory structure given some ant-style file patterns, or classpath resources.The sort algorithm to be applied to directory contents.A set of files that are in a specific order.ForByStep<T>The step in the creation of aFOR LOOPstatement where theBYclause can be supplied.AForeignKeyis an object referencing aUniqueKey.ForInStep<T>The step in the creation of aFOR LOOPstatement where theINclause can be supplied.A type that can format its contents.An SPI that allows for overriding certain formatting defaults.Function0<R>A function of degree 0.Function1<T1,R> A function of degree 1.Function10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, R> A function of degree 10.Function11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, R> A function of degree 11.Function12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, R> A function of degree 12.Function13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, R> A function of degree 13.Function14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, R> A function of degree 14.Function15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, R> A function of degree 15.Function16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, R> A function of degree 16.Function17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, R> A function of degree 17.Function18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, R> A function of degree 18.Function19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, R> A function of degree 19.Function2<T1,T2, R> A function of degree 2.Function20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, R> A function of degree 20.Function21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, R> A function of degree 21.Function22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22, R> A function of degree 22.Function3<T1,T2, T3, R> A function of degree 3.Function4<T1,T2, T3, T4, R> A function of degree 4.Function5<T1,T2, T3, T4, T5, R> A function of degree 5.Function6<T1,T2, T3, T4, T5, T6, R> A function of degree 6.Function7<T1,T2, T3, T4, T5, T6, T7, R> A function of degree 7.Function8<T1,T2, T3, T4, T5, T6, T7, T8, R> A function of degree 8.Function9<T1,T2, T3, T4, T5, T6, T7, T8, T9, R> A function of degree 9.Utilities related to the construction of functions.A generator can be used withDataType.generatedAlwaysAs(Generator)to implement dynamic, client side computed columns, i.e.AGeneratorContextis an argument object that is passed to aGeneratorwhen generating client side computed columns.The statement type of aGeneratorContext.A wrapper type for spatial data obtained from the database.A wrapper type for spatial data obtained from the database.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theGRANTstatement.A step in the construction of theGRANTstatement.A step in the construction of theGRANTstatement.MySQL'sGROUP_CONCATfunction.MySQL'sGROUP_CONCATfunction.An expression to be used exclusively inGROUP BYclauses.AnIdentityis an object representing anIDENTITYcolumn as understood by the SQL:2003 standard.An intermediate step in building a proceduralIFstatement.An intermediate step in building a proceduralIFstatement.A DDL index definition.AnINSERTstatement.InsertFinalStep<R extends Record>Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.InsertOnConflictConditionStep<R extends Record>This type is used for theInsert's DSL API.InsertOnConflictDoUpdateStep<R extends Record>This type is used for theInsert's DSL API.InsertOnConflictWhereIndexPredicateStep<R extends Record>This type is used for theInsert's DSL API.InsertOnConflictWhereStep<R extends Record>This type is used for theInsert's DSL API.InsertOnDuplicateSetMoreStep<R extends Record>This type is used for theInsert's DSL API.InsertOnDuplicateSetStep<R extends Record>This type is used for theInsert's DSL API.InsertOnDuplicateStep<R extends Record>This type is used for theInsert's DSL API.InsertQuery<R extends Record>AnINSERTstatement (model API).InsertResultStep<R extends Record>This type is used for theInsert's DSL API.InsertReturningStep<R extends Record>This type is used for theInsert's DSL API.InsertSetMoreStep<R extends Record>This type is used for theInsert's alternative DSL API.InsertSetStep<R extends Record>This type is used for theInsert's alternative DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.InsertValuesStep19<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.InsertValuesStep20<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> This type is used for theInsert's DSL API.InsertValuesStep21<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> This type is used for theInsert's DSL API.InsertValuesStep22<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.This type is used for theInsert's DSL API.InsertValuesStepN<R extends Record>This type is used for theInsert's DSL API.Deprecated.- 3.17.0 - [#13071] - UseApiStatus.Internalinstead.The type of join.A JSON wrapper type for JSON data obtained from the database.A step in the construction ofDSL.jsonArrayAgg(Field)orDSL.jsonbArrayAgg(Field)functions where theNULLclause can be defined.A step in the construction ofDSL.jsonArrayAgg(Field)orDSL.jsonbArrayAgg(Field)functions where theORDER BYclause can be defined.A step in the construction ofDSL.jsonArrayAgg(Field)orDSL.jsonbArrayAgg(Field)functions where theRETURNINGclause can be defined.A step in the construction of theJSON ARRAYfunction.A step in the construction of theJSON ARRAYfunction.A JSON wrapper type for JSONB data obtained from the database.JSONEntry<T>A JSON entry for JSON objects.A step in the creation ofJSONEntryvalues.A step in the construction ofDSL.jsonExists(Field, Field)orDSL.jsonbExists(Field, Field)functions where theON ERRORclause can be defined.A JSON formatting type, which can be used to configure JSON imports / exports.The format of individual JSON records.A step in the construction ofDSL.jsonObjectAgg(JSONEntry)orDSL.jsonbObjectAgg(JSONEntry)functions where theNULLclause can be defined.A step in the construction ofDSL.jsonObjectAgg(JSONEntry)orDSL.jsonbObjectAgg(JSONEntry)functions where theRETURNINGclause can be defined.A step in the construction of theJSON OBJECTfunction.A step in the construction of theJSON OBJECTfunction.A step in the construction of anJSON_TABLEexpression.A step in the construction of anJSON_TABLEexpression.A step in the construction of anJSON_TABLEexpression.A step in the construction of anJSON_TABLEexpression.A step in the construction ofDSL.jsonValue(Field, Field)orDSL.jsonbValue(Field, Field)functions where theON EMPTYandON ERRORclauses can be defined for default values.A step in the construction ofDSL.jsonValue(Field, Field)orDSL.jsonbValue(Field, Field)functions where theON EMPTYandON ERRORclauses can be defined.A step in the construction of theJSON VALUEfunction.AKeyis an object representing aUNIQUE KEY, aPRIMARY KEY, or aFOREIGN KEY.A SQL keyword.A label for use in procedural code.The current language context of someParseContextorRenderContext.A step in the construction of theLIKEfunction.A database link reference.TheLoaderAPI is used for configuring data loads.A context object that provides information about a loader's current state toLoaderRowListener.LoaderCSVOptionsStep<R extends Record>TheLoaderAPI is used for configuring data loads.LoaderCSVStep<R extends Record>TheLoaderAPI is used for configuring data loads.An error that occurred during loading.The argument object forLoaderFieldMapper.map(LoaderFieldContext).LoaderJSONOptionsStep<R extends Record>TheLoaderAPI is used for configuring data loads.LoaderJSONStep<R extends Record>TheLoaderAPI is used for configuring data loads.LoaderListenerStep<R extends Record>TheLoaderAPI is used for configuring data loads.LoaderLoadStep<R extends Record>TheLoaderAPI is used for configuring data loads.LoaderOptionsStep<R extends Record>TheLoaderAPI is used for configuring data loads.A listener forLoaderprogress.LoaderRowsStep<R extends Record>TheLoaderAPI is used for configuring data loads.LoaderSourceStep<R extends Record>TheLoaderAPI is used for configuring data loads.LoaderXMLStep<R extends Record>TheLoaderAPI is used for configuring data loads.A common logger abstraction API for jOOQ's internal logging.The log level.An intermediate step in building a proceduralLOOPstatement.AMERGEstatement.MergeFinalStep<R extends Record>Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep20<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep21<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStep22<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeKeyStepN<R extends Record>This type is used for the H2-specific variant of theMerge's DSL API.MergeMatchedDeleteStep<R extends Record>This type is used for theMerge's DSL API.MergeMatchedSetMoreStep<R extends Record>This type is used for theMerge's DSL API.MergeMatchedSetStep<R extends Record>This type is used for theMerge's DSL API.MergeMatchedStep<R extends Record>This type is used for theMerge's DSL API.MergeMatchedThenStep<R extends Record>This type is used for theMerge's DSL API.MergeMatchedWhereStep<R extends Record>This type is used for theMerge's DSL API.MergeNotMatchedSetMoreStep<R extends Record>This type is used for theMerge's DSL API.MergeNotMatchedSetStep<R extends Record>This type is used for theMerge's DSL API.MergeNotMatchedStep<R extends Record>This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.MergeNotMatchedValuesStep16<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep17<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep18<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep19<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.MergeNotMatchedValuesStep20<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep21<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> This type is used for theMerge's DSL API.MergeNotMatchedValuesStep22<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.This type is used for theMerge's DSL API.MergeNotMatchedValuesStepN<R extends Record>This type is used for theMerge's DSL API.MergeNotMatchedWhereStep<R extends Record>This type is used for theMerge's DSL API.MergeOnConditionStep<R extends Record>This type is used for theMerge's DSL API.MergeOnStep<R extends Record>This type is used for theMerge's DSL API.MergeUsingStep<R extends Record>This type is used for theMerge's DSL API.Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep19<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep20<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep21<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStep22<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)MergeValuesStepN<R extends Record>This type is used for the H2-specific variant of theMerge's DSL API.A wrapping object forDatabaseMetaDataor for other sources of database meta information (e.g.An SPI that can produce dynamic catalog, schema, table meta data information.An executable migration between twoCommitinstances.A configuration type for use with the variousMeta.migrateTo(Meta)methods.The context in which aMigrationis executed.A listener forMigrationlifecycles.A provider forMigrationListenerinstances.An identifier.A flag indicating whether the name is quoted or not.A common base type for all qualifiable, named objects.An abstraction over directed, acyclic graph models.AConditionthat always yieldsnull.An enum that specifies the nullability of aDataType.An operator used for combining conditions.An ordered-set aggregate function.An ordered-set aggregate function.OrderField<T>AQueryPartto be used exclusively inORDER BYclauses.A container for stored procedures and functionsParam<T>A named parameter and/or bind value.Parameter<T>A parameter to a stored procedure or function.The mode of aParam.A publicly available API for the internal parse context that allows for parsing SQL fragements.A listener that allows for parsing custom SQL.A provider forParseListenerinstances.A SQL parser.A command line interface to the Parser API, which works in a similar way as https://www.jooq.org/translate.Period<T>A period specification for usage in temporal tables.This type is used for the OraclePIVOTclause DSL API, pivotingTableobjects to new tables.PivotInStep<T>This type is used for the OraclePIVOTclause DSL API, pivotingTableobjects to new tables.This annotation marks all methods and types that allow for producing aQueryPartthat generates "plain SQL" inside of an AST.A privilege for use inGRANTandREVOKEstatements.An annotation that indicates that any given API is available to the commercial jOOQ distributions only, including the jOOQ Express Edition, the jOOQ Professional Edition, and the jOOQ Enterprise Edition.Publisher<T>A bridge fromFlow.PublishertoPublisherfor compatibility purposes.A qualified asterisk.QualifiedRecord<R extends QualifiedRecord<R>>QuantifiedSelect<R extends Record>A quantified select for use in quantified comparison predicates.A wrapper for a collection of queries.Any query.The common base type for all objects that can be used for query composition.Base functionality declaration for all query objectsA database result record.Record1<T1>A model type for a records with degree1Record10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10> A model type for a records with degree10Record11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> A model type for a records with degree11Record12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> A model type for a records with degree12Record13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> A model type for a records with degree13Record14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> A model type for a records with degree14Record15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> A model type for a records with degree15Record16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> A model type for a records with degree16Record17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> A model type for a records with degree17Record18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> A model type for a records with degree18Record19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> A model type for a records with degree19Record2<T1,T2> A model type for a records with degree2Record20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> A model type for a records with degree20Record21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> A model type for a records with degree21Record22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> A model type for a records with degree22Record3<T1,T2, T3> A model type for a records with degree3Record4<T1,T2, T3, T4> A model type for a records with degree4Record5<T1,T2, T3, T4, T5> A model type for a records with degree5Record6<T1,T2, T3, T4, T5, T6> A model type for a records with degree6Record7<T1,T2, T3, T4, T5, T6, T7> A model type for a records with degree7Record8<T1,T2, T3, T4, T5, T6, T7, T8> A model type for a records with degree8Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9> A model type for a records with degree9A context object forRecordmanipulation passed to registeredRecordListener's.RecordHandler<R extends Record>Deprecated, for removal: This API element is subject to removal in a future version.- 3.15.0 - [#11902] - UseIterable.forEach(Consumer)based methods, instead.A listener for manipulation events onUpdatableRecords.A provider forRecordListenerinstances.ARecordMapperis a mapper that can receiveRecordobjects, when fetching data from the database, transforming them into a custom type<E>.A provider forRecordMapperinstances.RecordQualifier<R extends Record>Common utilities related toRecordtypes and constructingRecordMapper.RecordType<R extends Record>RecordUnmapper<E,R extends Record> ARecordUnmapperis a mapper that can receive user objects and convert them back toRecord.A provider forRecordUnmapperinstances.The render context is used for renderingQueryPart's to SQL.The cast mode for bind values.An intermediate step in building a proceduralREPEATstatement.An API forQueryPart.$replace(Replacer)query part transformations.A set ofReplacerconstructor methods.Require a set ofSQLDialectto be supported by any jOOQ statement in the scope of this annotation.A scope that can manage resources.A wrapper for database results returned by.SelectQueryA type that contains either aResult, an update count, or an exception.ResultQuery<R extends Record>A query that can return results.A list ofResultand update counts that can be returned byResultQuery.fetchMany()calls and other calls that produce multiple cursors and update counts.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.A step in the construction of theREVOKEstatement.A step in the construction of theREVOKEstatement.A privilege for use inGRANTandREVOKEstatements.Routine<T>A routine is a callable object in your RDBMS.A row value expression.Row1<T1>A row value expression.Row10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10> A row value expression.Row11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> A row value expression.Row12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> A row value expression.Row13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> A row value expression.Row14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> A row value expression.Row15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> A row value expression.Row16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> A row value expression.Row17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> A row value expression.Row18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> A row value expression.Row19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> A row value expression.Row2<T1,T2> A row value expression.Row20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> A row value expression.Row21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> A row value expression.Row22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> A row value expression.Row3<T1,T2, T3> A row value expression.Row4<T1,T2, T3, T4> A row value expression.Row5<T1,T2, T3, T4, T5> A row value expression.Row6<T1,T2, T3, T4, T5, T6> A row value expression.Row7<T1,T2, T3, T4, T5, T6, T7> A row value expression.Row8<T1,T2, T3, T4, T5, T6, T7, T8> A row value expression.Row9<T1,T2, T3, T4, T5, T6, T7, T8, T9> A row value expression.Any query that is not aResultQuery, and thus possibly produces a row count as a result, instead of aResult.A data type corresponding to JDBC'sTypes.ROWID.A row value expression.An auxiliary class for constructingRowcollections.A schema.Deprecated, for removal: This API element is subject to removal in a future version.- 2.0.5 - Use runtime configurationSettingsinsteadScope implementations provide access to a variety of objects that are available from a given scope.ASELECTstatement.SelectConditionStep<R extends Record>SelectConnectByAfterStartWithConditionStep<R extends Record>SelectConnectByAfterStartWithStep<R extends Record>SelectConnectByConditionStep<R extends Record>SelectConnectByStep<R extends Record>SelectCorrelatedSubqueryStep<R extends Record>SelectDistinctOnStep<R extends Record>SelectField<T>AQueryPartto be used exclusively inSELECTclauses.AQueryPartto be used exclusively inSELECTclauses.SelectFinalStep<R extends Record>SelectForJSONCommonDirectivesStep<R extends Record>SelectForJSONStep<R extends Record>SelectForStep<R extends Record>SelectForUpdateOfStep<R extends Record>SelectForUpdateStep<R extends Record>SelectForUpdateWaitStep<R extends Record>SelectForXMLCommonDirectivesStep<R extends Record>SelectForXMLPathDirectivesStep<R extends Record>SelectForXMLRawDirectivesStep<R extends Record>SelectForXMLStep<R extends Record>SelectFromStep<R extends Record>SelectGroupByStep<R extends Record>SelectHavingConditionStep<R extends Record>SelectHavingStep<R extends Record>SelectIntoStep<R extends Record>SelectJoinPartitionByStep<R extends Record>SelectJoinStep<R extends Record>SelectLimitAfterOffsetStep<R extends Record>SelectLimitPercentAfterOffsetStep<R extends Record>SelectLimitPercentStep<R extends Record>SelectLimitStep<R extends Record>SelectOffsetStep<R extends Record>SelectOnConditionStep<R extends Record>SelectOnStep<R extends Record>SelectOptionalOnStep<R extends Record>SelectOptionStep<R extends Record>SelectOrderByStep<R extends Record>SelectQualifyConditionStep<R extends Record>SelectQualifyStep<R extends Record>SelectQuery<R extends Record>ASELECTstatement (model API).SelectSeekLimitStep<R extends Record>SelectSeekStep19<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> SelectSeekStep20<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> SelectSeekStep21<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> SelectSeekStep22<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> SelectSeekStepN<R extends Record>SelectSelectStep<R extends Record>SelectStartWithStep<R extends Record>SelectUnionStep<R extends Record>SelectWhereStep<R extends Record>SelectWindowStep<R extends Record>SelectWithTiesAfterOffsetStep<R extends Record>SelectWithTiesStep<R extends Record>A sequence.A step in the construction of theSIGNAL SQL STATEfunction.SortField<T>A sort specification.The sorting order used inORDER BYclauses.A source of text data.A wrapper type for spatial data obtained from the database.A plain SQLQueryPart.Dialects and dialect families as supported by jOOQ.A statement that can be placed inside of aBlock, but not executed on its own.StoreQuery<R extends Record>A query storing objects to the database.A container for annotations on stringly typed API.The annotated string type represents a keywordComment, which will be wrapped byDSL.comment(String).The annotated string type represents a keywordKeyword, which will be wrapped byDSL.keyword(String).The annotated string type represents an identifier, i.e.The annotated string type represents a bind variable, i.e.The annotated string type represents a plain SQL template, i.e.A formal declaration of whether any API element is supported by a givenSQLDialectA table.A field contained in a table.An object that can behave like a table (a table-like object).TableOnConditionStep<R extends Record>An intermediate (optional) type for the construction of aJOINclause, where the join criteria is added using anONclause (with aCondition.TableOnStep<R extends Record>TableOptionalOnStep<R extends Record>A description of various additionalTableoptions to describe the table runtime meta model.TheON COMMITflag forTableOptions.TableType.TEMPORARYtables.A description of the type of aTable.TableOuterJoinStep<R extends Record>An intermediate type for the construction of a partitionedSQLDialect.ORACLEOUTER JOINclause.TablePartitionByStep<R extends Record>An intermediate type for the construction of a partitionedSQLDialect.ORACLEOUTER JOINclause.TableRecord<R extends TableRecord<R>>A record originating from a single tableA custom transaction object.AnFunctionalInterfacethat wraps transactional code.AnFunctionalInterfacethat wraps transactional code for reactive usage.AnFunctionalInterfacethat wraps transactional code.A context object that is used to pass arguments to the various methods ofTransactionProvider.TheTransactionListenerSPI is used to intercept theTransactionProvider's transaction events.A provider forTransactionListenerinstances.TheTransactionProviderSPI can be used to implement customtransactionbehaviour that is applied when callingDSLContext.transactionResult(TransactionalCallable)orDSLContext.transaction(TransactionalRunnable).An SPI to provide SQL transformation configuration and behaviour.Traverser<A,R> An API forQueryPart.$traverse(Traverser)query part traversals.A set ofTraverserconstructor methods.AConditionthat always yieldstrue.A step in the construction of theTRUNCATEstatement.TruncateCascadeStep<R extends Record>A step in the construction of theTRUNCATEstatement.TruncateFinalStep<R extends Record>Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.TruncateIdentityStep<R extends Record>A step in the construction of theTRUNCATEstatement.A text formatting type, which can be used to configure text imports / exports.Typed<T>A marker interface for all query parts that have aDataType.UDT definition.A field contained in a UDT.An object holding data of a UDTAUniqueKeyis an object representing aUNIQUE KEYor aPRIMARY KEY.An unwrapper SPI that can be used to override the default unwrapping algorithm.A provider for theUnwrapperSPI which is used to override the default behaviour when unwrapping JDBC types throughWrapper.unwrap(Class).UpdatableRecord<R extends UpdatableRecord<R>>A common interface for records that can be stored back to the database again.AnUPDATEstatement.UpdateConditionStep<R extends Record>This type is used for theUpdate's DSL API.UpdateFinalStep<R extends Record>Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.UpdateFromStep<R extends Record>This type is used for theUpdate's DSL API.UpdateLimitStep<R extends Record>This type is used for theUpdate's DSL API.UpdateOrderByStep<R extends Record>This type is used for theUpdate's DSL API.UpdateQuery<R extends Record>AnUPDATEstatement (model API).UpdateResultStep<R extends Record>This type is used for theUpdate's DSL API.UpdateReturningStep<R extends Record>This type is used for theUpdate's DSL API.UpdateSetFirstStep<R extends Record>This type is used for theUpdate's DSL API.UpdateSetMoreStep<R extends Record>This type is used for theUpdate's DSL API.UpdateSetStep<R extends Record>This type is used for theUpdate's DSL API.UpdateWhereStep<R extends Record>This type is used for theUpdate's DSL API.A privilege for use inGRANTandREVOKEstatements.Variable<T>A local variable reference.A version ID attached to aMetadescription of a database.A directed, acyclic graph ofVersionobjects.This type is used for the OracleVERSIONSclause DSL API, providing access to the flashback versions query clauses.A context object forQueryParttraversal passed to registeredVisitListener's.A listener forQueryParttraversal events.A provider forVisitListenerinstances.This type is used for the window function DSL API.A window definition.This type is used for the window function DSL API.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.This type is used for the window function DSL API.This type is used for the window function DSL API.This type is used for the window function DSL API.This type is used for the window function DSL API.This type is used for the window function DSL API.This type is used for the window function DSL API.This type is used for the window function DSL API.A window specification.An intermediate step in the construction of aWindowSpecification.Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.An intermediate step in the construction of aWindowSpecification.An intermediate step in the construction of aWindowSpecification.An intermediate step in the construction of aWindowSpecification.An intermediate step in the construction of aWindowSpecification.An XML wrapper type for XML data obtained from the database.The SQL standardARRAY_AGG()function.A type modelling XML attributes for use inDSL.xmlelement(Name, XMLAttributes, Field...).A step in the construction of anXMLEXISTSpredicate.An XML formatting type, which can be used to configure XML imports / exports.The format of individual XML records.A step in the construction of anXMLQUERYexpression.A step in the construction of anXMLTABLEexpression.A step in the construction of anXMLTABLEexpression.A step in the construction of anXMLTABLEexpression.A step in the construction of anXMLTABLEexpression.A step in the construction of anXMLTABLEexpression.