Package org.hibernate.dialect.sql.ast.spi
package org.hibernate.dialect.sql.ast.spi
Dialect contracts for selecting SQL AST translators and
expressing database-specific SQL AST rendering behavior.
- Since:
- 8.0
-
ClassDescriptionSupported provider base for a SQL AST expression which renders itself.AbstractSqlAstTranslator<T extends JdbcOperation>Supported generic base for translating query and model-mutation SQL ASTs.The transition-image exposed by a data-change table expression.Immutable description of a Dialect's common-table-expression (CTE) capabilities.Builder for immutable
CteSupportprofiles.Mutation-specific CTE capabilities.The strongest location in which a WITH clause may occur.Native recursive-CTE syntax capabilities.DB2-family query-mutation rendering policy.DB2SqlAstTranslator<T extends JdbcOperation>A SQL AST translator for DB2.Immutable semantic plan for rendering a query delete.Render the delete directly using the translator's native delete grammar.Move joins which cannot appear directly in the delete into a correlatedexistssubquery in the where clause.Read-only semantic facts supplied by Hibernate when selecting how to render a query delete.Selects where a derived table's column aliases are rendered.The semantic kind of derived table being rendered.Immutable plan selected byDerivedTableRenderingSupportfor rendering a derived-table reference.Rendering choices for a function table reference.Rendering choices for a derived query part.Rendering choices for a derived values table.Read-only semantic facts supplied by Hibernate when selecting how to render a derived-table reference.Dialect strategy for selecting an immutable rendering plan for a derived-table reference.The qualifier form a database accepts for references to target columns in update and delete statements.Syntax used to express a do-nothing action in an on-duplicate-key clause.Immutable description of thefetchclause forms accepted by a database.Emulates ANSIFULL JOINusing set operators.Semantic action requested by an insert conflict clause.Immutable plan for rendering insert-conflict semantics.Render an ordinary single-row insert and emulatedo nothingby handling an eligible unique-constraint violation during execution.Render a do-update insert as amergestatement.Render an ordinary insert because no conflict action was requested.Render anon duplicate key updateclause.Render standardon conflictsyntax from the complete semantic conflict clause.Read-only semantic facts supplied by Hibernate when selecting how to render an insert-conflict clause.Dialect strategy for selecting an immutable plan for insert-conflict semantics.Selects how a lateral derived-table reference is introduced.The kind of SQL mutation statement whose syntax is being described.A native SQL mutation-syntax capability.Immutable description of a Dialect's native SQL mutation syntax.Build an immutable mutation-syntax profile.The ordering of null values used by a Dialect'sNullOrderingSupport.getDefaultOrdering()profile value.Immutable description of a Dialect's default null ordering and native explicit null-precedence syntax.Build an immutable null-ordering-support profile.An independently configurable null-ordering syntax capability.The complete provider input for selecting or constructing an optional-table update operation.Immutable semantic plan for SQL AST pagination rendering.A combined trailing limit clause whose first operand is the offset and second operand is the row count, for exampleselect ... limit 5, 10.A trailing fetch clause whose count is increased by the offset.A select-clausefirstform without native offset syntax.A select-clausefirst ... skip ...form, for exampleselect first 10 skip 5 ....Separate trailinglimitandoffsetclauses, for exampleselect ... limit 10 offset 5.No SQL AST pagination syntax.ANSI offset/fetch syntax rendered at the end of the query part.A trailing inclusive row range, for exampleselect ... rows 5 to 14for a ten-row range beginning at the database-specific first-row value.A select-clauseskip ... first ...form, for exampleselect skip 5 first 10 ....Atopclause rendered immediately afterselect.A select-clausetop ... start at ...form, for exampleselect top 10 start at 5 ....Emulate pagination by wrapping the query part and filtering a derived row number.Read-only semantic facts supplied by Hibernate when selecting how to render pagination for one query part.Dialect strategy for selecting the SQL rendering plan for a paginated query part.PostgreSQLFamilySqlAstTranslator<T extends JdbcOperation>Supported SQL AST translator base for PostgreSQL-derived databases.PostgreSQLSqlAstTranslator<T extends JdbcOperation>A SQL AST translator for PostgreSQL.Immutable description of a Dialect's native predicate syntax and predicate placement support.Build an immutable predicate-support profile.An independently configurable predicate capability.Read-only semantic context for rendering a prefix before a primary table reference.The semantic kind of primary table reference.Dialect strategy for selecting immutable rendering plans for query-language update and delete statements.The semantic source of a mutation requesting returned columns.Immutable plan selected byReturningRenderingSupportfor returning generated mutation values.Wrap the mutation in anold,new, orfinaldata-change table and select the requested columns from the wrapper.Render a standard trailingreturningclause after the mutation.Render only the mutation because no columns were requested.Read-only semantic facts supplied by Hibernate when selecting how a mutation returns generated column values.Dialect strategy for selecting an immutable plan for returning generated column values from a mutation.Immutable description of a Dialect's native row-value syntax.Build an immutable row-value-support profile.An independently configurable row-value syntax feature.How a SQL AST translator refers to a select item from agroup byclause.Immutable description of a Dialect's set-operation grammar.Build an immutable set-operation-support profile.An independently configurable structural set-operation capability.Immutable semantic plan for rendering a named set-returning function.Emulate the requested ordinality column using a derived table.Wrapper applied to the function invocation inside the derived table.SQL expression used to synthesize ordinality.Render the native function invocation, optionally followed by nativewith ordinalitysyntax.Native ordinality syntax to append to the invocation.Wrap the invocation with the database'stable(...)syntax.Report that the requested invocation cannot be rendered safely.Read-only semantic facts supplied by Hibernate when selecting how to render a named set-returning function.Dialect strategy for selecting an immutable rendering plan for a named set-returning function.Immutable description of the SQL used by a Dialect for a reusable single-row table and for an otherwise table-less select.Build an immutable single-row-table-support profile.The complete, typed input supplied by Hibernate to create one SQL AST translator.Request to translate a mapping-model table mutation into its matching JDBC mutation operation.Request to translate a query-language update or delete into aJdbcOperationQueryMutation.Request to translate a query select into aJdbcSelect.Factory supplied by a Dialect for creating single-use SQL AST translators.SqlAstTranslatorWithMerge<T extends JdbcOperation>Supported provider base for translators which implement a full insert-or-update-or-deleteMERGEcommand.SqlAstTranslatorWithUpsert<T extends JdbcOperation>Deprecated, for removal: This API element is subject to removal in a future version.Reusable pagination-plan selection for SQL Server syntax families.Standard and family derived-table rendering profiles.Standard immutable insert-conflict rendering profiles.Standard immutable fixed-plan pagination profiles.Standard immutable query-mutation rendering profiles.Standard and family returning-column rendering profiles.Standard and family named set-returning-function rendering strategies.StandardSqlAstTranslator<T extends JdbcOperation>The final phase of query translation.StandardSqlAstTranslatorFactoryand supported base for custom factories.Standard and family table-join rendering strategies.Immutable description of the subquery placements supported by a Dialect.Build an immutable subquery-support profile.An independently configurable subquery placement.Immutable description of a synthetic table root required while building a SQL AST query specification.Determines whether resolving a grouping or ordering expression requires a synthetic table root in the current SQL AST query specification.The semantic kind of table join being rendered.Immutable semantic plan for rendering a table join.Render SQL Server-stylecross applyorouter applysyntax.The concreteapplyoperator.Render the joined table as a comma-separated table reference.Render the SQL AST join type and its predicate using standard syntax.Report that the requested join cannot be rendered without changing its semantics.Read-only semantic facts supplied by Hibernate when selecting how to render a table join.Dialect strategy for selecting an immutable rendering plan for a table join.The semantic location where a table-reference alias is rendered.Immutable semantic plan for rendering a query update.Render the update directly using native syntax.Emulate the update using an inline view.Emulate the update using a merge statement.Emulate the from-clause using scalar subqueries in the set clause.Emulate the update using tuple assignment.Read-only semantic facts supplied by Hibernate when selecting how to render a query update.Immutable description of the contexts in which a Dialect supports nativevaluessyntax.A SQL context in which a values list may occur.How an on-duplicate-key clause refers to the proposed insert row.Selects the SQL form used for a values-table source.