org.hibernate.dialect.function (Hibernate JavaDocs)

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
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)`.
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.
DB2FormatEmulation	DB2's varchar_format() can't handle quoted literal strings in the format pattern.
DerbyLpadEmulation	A derby implementation for lpad.
DerbyRpadEmulation	A derby implementation for rpad.
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.
PostgreSQLMinMaxFunction	PostgreSQL doesn't support min/max for uuid yet, but since that type is comparable we want to support this operation.
QuantifiedLeastGreatestEmulation
SqlFunction	A function to pass through a SQL fragment.
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.
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, char)`.

Package org.hibernate.dialect.function