org.hibernate.dialect.function (Hibernate Javadocs)

Contains implementations of SqmFunctionDescriptor describing a range of relatively-sophisticated SQL functions available in various dialects.

Class Summary
Class	Description
AggregateWindowEmulationQueryTransformer	Since the query spec will render a hypothetical set window function instead of an aggregate, the following query transformer will wrap the query spec and apply aggregation in the outer query.
AvgFunction
AvgFunction.ReturnTypeResolver
AvgFunction.Validator
CaseLeastGreatestEmulation	Some databases don't have a function like `least()` or `greatest()`, and on those platforms we emulate the function using `case`.
CastFunction	ANSI SQL-inspired `cast()` function, where the target types are enumerated by `CastType`, and portability is achieved by delegating to `Dialect.castPattern(CastType, CastType)`.
CastingConcatFunction
CastStrEmulation	The HQL `str()` function is now considered a synonym for `cast(x as String)`.
ChrLiteralEmulation	A chr implementation that translates integer literals to string literals.
CoalesceIfnullEmulation
CommonFunctionFactory	Enumeratoes common function template definitions.
ConcatPipeFunction	A concat function with a pattern for clob arguments.
CountFunction
CurrentFunction	A "function" with no parameters that returns the current date, time, or timestamp.
DateTruncEmulation	Emulation of `trunc(datetime, temporal_unit)` function that leverages formatting the datetime to string and back to truncate it
DB2FormatEmulation	DB2's varchar_format() can't handle quoted literal strings in the format pattern.
DB2PositionFunction	DB2's position() function always requires a code unit before version 11.
DB2SubstringFunction	DB2's substring() function requires a code unit and substr() can't optionally take it, so we render substr() by default.
DerbyLpadEmulation	A derby implementation for lpad.
DerbyRpadEmulation	A derby implementation for rpad.
DynamicDispatchFunction	A function that dynamically dispatches to other functions, depending on which function validates successfully first.
EveryAnyEmulation	Most databases don't have a function like `every()` or `any()`.
ExtractFunction	ANSI SQL-inspired `extract()` function, where the date/time fields are enumerated by `TemporalUnit`, and portability is achieved by delegating to `Dialect.extractPattern(TemporalUnit)`.
FormatFunction	A format function with support for composite temporal expressions.
FormatFunction.FormatSqmFunction<T>
HypotheticalSetFunction
HypotheticalSetWindowEmulation
InsertSubstringOverlayEmulation	Emulates the ANSI SQL-standard `overlay()` function using `insert()` `substring()`, and `concat()`.
IntegralTimestampaddFunction	Used in place of `TimestampaddFunction` for databases which don't support fractional seconds in the `timestampadd()` function.
InverseDistributionFunction
InverseDistributionWindowEmulation
LengthFunction	A length function with separate patterns for string and clob argument.
ListaggFunction
ListaggGroupConcatEmulation
ListaggStringAggEmulation
LocatePositionEmulation	Emulates the ANSI SQL-standard `position()` function using `locate()`.
LpadRpadPadEmulation	HQL function inspired by the ANSI SQL trim function, with a funny syntax involving a `TrimSpec`.
MinMaxCaseEveryAnyEmulation	Most databases don't have a function like `every()` or `any()`.
ModeStatsModeEmulation
NvlCoalesceEmulation	Oracle 8i had no `coalesce()` function, so we emulate it using chained `nvl()`s.
OracleTruncFunction	Custom `TruncFunction` for Oracle which uses emulation when truncating datetimes to seconds
PostgreSQLMinMaxFunction	PostgreSQL doesn't support min/max for uuid yet, but since that type is comparable we want to support this operation.
PostgreSQLTruncFunction	Custom `TruncFunction` for PostgreSQL which uses the dialect-specific function for numeric truncation
PostgreSQLTruncRoundFunction	PostgreSQL only supports the two-argument `trunc` and `round` functions with the following signatures: `trunc(numeric, integer)` `round(numeric, integer)`
QuantifiedLeastGreatestEmulation
SqlColumn
SqlFunction	A function to pass through a SQL fragment.
SqlServerConvertTruncFunction	Custom `TruncFunction` for SQL Server versions before 16, which uses the custom `SqlServerConvertTruncFunction.DateTruncConvertEmulation`
SQLServerEveryAnyEmulation	SQL Server doesn't have a function like `every()` or `any()`.
SQLServerFormatEmulation	SQL Server behaves strangely when the first argument to format is of the type time, so we cast to datetime.
StandardSQLFunction	Simplified API allowing users to contribute `SqmFunctionDescriptor`s to HQL.
SumReturnTypeResolver	Resolve according to JPA spec 4.8.5
SybaseTruncFunction	Custom `TruncFunction` for Sybase which uses a dialect-specific emulation function for datetimes
TimestampaddFunction	The `timestampadd()` or `dateadd()` function has a funny syntax which accepts a `TemporalUnit` as the first argument, and the actual set of accepted units varies widely.
TimestampdiffFunction	The `timestampdiff()` or `datediff()` function has a funny syntax which accepts a `TemporalUnit` as the first argument, and the actual set of accepted units varies widely.
TransactSQLStrFunction	A special function that renders a T-SQL `str()` function if more than a single argument is given, or otherwise renders a `cast()` expression just like `CastStrEmulation`.
TrimFunction	ANSI SQL-standard `trim()` function, which has a funny syntax involving a `TrimSpec`, and portability is achieved using `Dialect.trimPattern(TrimSpec, boolean)`.
TruncFunction	Custom function that manages both numeric and datetime truncation
TruncFunction.TruncArgumentsValidator
TruncFunction.TruncRenderingSupport

Enum Summary
Enum Description

TruncFunction.DatetimeTrunc

Package org.hibernate.dialect.function