java.lang.Object
- org.hibernate.query.sqm.internal.SqmCriteriaNodeBuilder

All Implemented Interfaces:

CriteriaBuilder, Serializable, HibernateCriteriaBuilder, NodeBuilder, SqmCreationContext
```
public class SqmCriteriaNodeBuilder
extends Object
implements NodeBuilder, SqmCreationContext, Serializable
```
Acts as a JPA CriteriaBuilder by using SQM nodes as the JPA Criteria nodes

See Also:

Serialized Form

Nested Class Summary
- Nested classes/interfaces inherited from interface jakarta.persistence.criteria.CriteriaBuilder
  CriteriaBuilder.Case<R extends Object>, CriteriaBuilder.Coalesce<T extends Object>, CriteriaBuilder.In<T extends Object>, CriteriaBuilder.SimpleCase<C extends Object,R extends Object>, CriteriaBuilder.Trimspec

Constructor Summary

Constructors
Constructor	Description
`SqmCriteriaNodeBuilder(String uuid, String name, QueryEngine queryEngine, boolean jpaComplianceEnabled, ValueHandlingMode criteriaValueHandlingMode, ServiceRegistry serviceRegistry, Supplier<SessionFactoryImplementor> sessionFactory)`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`<N extends Number> SqmExpression<N>`	`abs(Expression<N> x)`
`SqmFunction<Double>`	`acos(Expression<? extends Number> x)`	Create an expression that returns the inverse cosine of its argument.
`<Y> SqmModifiedSubQueryExpression<Y>`	`all(Subquery<Y> subquery)`
`SqmPredicate`	`and(Expression<Boolean> x, Expression<Boolean> y)`
`SqmPredicate`	`and(Predicate... restrictions)`
`<Y> SqmModifiedSubQueryExpression<Y>`	`any(Subquery<Y> subquery)`
`static boolean`	`areTypesComparable(SqmExpressible<?> lhsType, SqmExpressible<?> rhsType)`
`JpaCompoundSelection<Object[]>`	`array(Selection<?>[] selections)`
`<Y> JpaCompoundSelection<Y>`	`array(Class<Y> resultClass, Selection<?>[] selections)`
`<Y> JpaCompoundSelection<Y>`	`array(Class<Y> resultClass, List<? extends JpaSelection<?>> selections)`
`JpaCompoundSelection<Object[]>`	`array(List<? extends JpaSelection<?>> selections)`
`SqmSortSpecification`	`asc(Expression<?> x)`
`JpaOrder`	`asc(Expression<?> x, boolean nullsFirst)`	Create an ordering by the ascending value of the expression.
`JpaSearchOrder`	`asc(JpaCteCriteriaAttribute x)`	Create a search ordering by the ascending value of the CTE attribute.
`JpaSearchOrder`	`asc(JpaCteCriteriaAttribute x, boolean nullsFirst)`	Create a search ordering by the ascending value of the CTE attribute.
`SqmFunction<Double>`	`asin(Expression<? extends Number> x)`	Create an expression that returns the inverse sine of its argument.
`void`	`assertComparable(Expression<?> x, Expression<?> y)`
`SqmFunction<Double>`	`atan(Expression<? extends Number> x)`	Create an expression that returns the inverse tangent of its argument.
`SqmFunction<Double>`	`atan2(Expression<? extends Number> y, Expression<? extends Number> x)`	Create an expression that returns the inverse tangent of `y` over `x`.
`SqmFunction<Double>`	`atan2(Expression<? extends Number> y, Number x)`
`SqmFunction<Double>`	`atan2(Number y, Expression<? extends Number> x)`
`<N extends Number> SqmExpression<Double>`	`avg(Expression<N> argument)`
`<N extends Number> SqmExpression<Double>`	`avg(Expression<N> argument, JpaPredicate filter)`
`<N extends Number> SqmExpression<Double>`	`avg(Expression<N> argument, JpaPredicate filter, JpaWindow window)`	Create an `avg` aggregate function expression.
`<N extends Number> SqmExpression<Double>`	`avg(Expression<N> argument, JpaWindow window)`
`<Y extends Comparable<? super Y>> SqmPredicate`	`between(Expression<? extends Y> value, Expression<? extends Y> lower, Expression<? extends Y> upper)`
`<Y extends Comparable<? super Y>> SqmPredicate`	`between(Expression<? extends Y> value, Y lower, Y upper)`
`<X,T> SqmExpression<X>`	`cast(JpaExpression<T> expression, Class<X> castTargetJavaType)`
`<N extends Number> JpaExpression<N>`	`ceiling(Expression<N> x)`	Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.
`void`	`close()`
`<T> SqmCoalesce<T>`	`coalesce()`
`<Y> JpaCoalesce<Y>`	`coalesce(Expression<? extends Y> x, Expression<? extends Y> y)`
`<Y> JpaCoalesce<Y>`	`coalesce(Expression<? extends Y> x, Y y)`
`SqmFunction<String>`	`collate(Expression<String> x, String collation)`
`SqmExpression<String>`	`concat(Expression<String> x, Expression<String> y)`
`SqmExpression<String>`	`concat(Expression<String> x, String y)`
`SqmExpression<String>`	`concat(String x, Expression<String> y)`
`SqmExpression<String>`	`concat(String x, String y)`
`SqmPredicate`	`conjunction()`
`<Y> JpaCompoundSelection<Y>`	`construct(Class<Y> resultClass, Selection<?>[] arguments)`
`<Y> JpaCompoundSelection<Y>`	`construct(Class<Y> resultClass, List<? extends JpaSelection<?>> arguments)`
`SqmFunction<Double>`	`cos(Expression<? extends Number> x)`	Create an expression that returns the cosine of its argument.
`SqmFunction<Double>`	`cosh(Expression<? extends Number> x)`	Create an expression that returns the hyperbolic cosine of its argument.
`SqmExpression<Long>`	`count(Expression<?> argument)`
`SqmExpression<Long>`	`count(Expression<?> argument, JpaPredicate filter)`
`SqmExpression<Long>`	`count(Expression<?> argument, JpaPredicate filter, JpaWindow window)`	Create a `count` aggregate function expression.
`SqmExpression<Long>`	`count(Expression<?> argument, JpaWindow window)`
`SqmExpression<Long>`	`countDistinct(Expression<?> argument)`
`<T> SqmDeleteStatement<T>`	`createCriteriaDelete(Class<T> targetEntity)`
`<T> SqmInsertSelectStatement<T>`	`createCriteriaInsertSelect(Class<T> targetEntity)`
`<T> SqmUpdateStatement<T>`	`createCriteriaUpdate(Class<T> targetEntity)`
`SqmSelectStatement<Object>`	`createQuery()`
`<T> SqmSelectStatement<T>`	`createQuery(Class<T> resultClass)`
`SqmSelectStatement<Tuple>`	`createTupleQuery()`
`SqmWindow`	`createWindow()`	Create an empty `JpaWindow` to use with window and aggregate functions.
`SqmExpression<Double>`	`cumeDist(JpaWindow window)`	Create a `cume_dist` window function expression.
`SqmFunction<Date>`	`currentDate()`
`SqmFunction<Instant>`	`currentInstant()`
`SqmFunction<Time>`	`currentTime()`
`SqmFunction<Timestamp>`	`currentTimestamp()`
`SqmFunction<Integer>`	`day(Expression<? extends TemporalAccessor> datetime)`	Extracts the `TemporalUnit.DAY` of a date, time, or datetime expression.
`SqmFunction<Double>`	`degrees(Expression<? extends Number> x)`	Create an expression that converts an angle measured in radians to an approximately equivalent angle measured in degrees.
`SqmExpression<Long>`	`denseRank(JpaWindow window)`	Create a `dense_rank` window function expression.
`SqmSortSpecification`	`desc(Expression<?> x)`
`JpaOrder`	`desc(Expression<?> x, boolean nullsFirst)`	Create an ordering by the descending value of the expression.
`JpaSearchOrder`	`desc(JpaCteCriteriaAttribute x)`	Create a search ordering by the descending value of the CTE attribute.
`JpaSearchOrder`	`desc(JpaCteCriteriaAttribute x, boolean nullsFirst)`	Create a search ordering by the descending value of the CTE attribute.
`<N extends Number> SqmExpression<N>`	`diff(Expression<? extends N> x, Expression<? extends N> y)`
`<N extends Number> SqmExpression<N>`	`diff(Expression<? extends N> x, N y)`
`<N extends Number> SqmExpression<N>`	`diff(N x, Expression<? extends N> y)`
`SqmPredicate`	`disjunction()`
`SqmPredicate`	`distinctFrom(Expression<?> x, Expression<?> y)`
`SqmPredicate`	`distinctFrom(Expression<?> x, Object y)`
`SqmPredicate`	`equal(Expression<?> x, Expression<?> y)`
`SqmPredicate`	`equal(Expression<?> x, Object y)`
`<T> JpaCriteriaQuery<T>`	`except(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)`
`<T> JpaSubQuery<T>`	`except(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)`
`SqmPredicate`	`exists(Subquery<?> subQuery)`
`JpaExpression<Double>`	`exp(Expression<? extends Number> x)`	Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.
`<T> SqmExpression<T>`	`firstValue(Expression<T> argument, JpaWindow window)`	Create a `first_value` window function expression.
`<P,F> SqmExpression<F>`	`fk(Path<P> path)`
`<N extends Number> JpaExpression<N>`	`floor(Expression<N> x)`	Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument.
`SqmFunction<String>`	`format(Expression<? extends TemporalAccessor> datetime, String pattern)`	Format a date, time, or datetime according to a pattern.
`SqmWindowFrame`	`frameBetweenFollowing(int offset)`
`SqmWindowFrame`	`frameBetweenFollowing(Expression<?> offset)`	Create a window frame of type `FrameKind.OFFSET_FOLLOWING` to use with `JpaWindow`s.
`SqmWindowFrame`	`frameBetweenPreceding(int offset)`
`SqmWindowFrame`	`frameBetweenPreceding(Expression<?> offset)`	Create window frame of type `FrameKind.OFFSET_PRECEDING` to use with `JpaWindow`s.
`SqmWindowFrame`	`frameCurrentRow()`	Create a window frame of type `FrameKind.CURRENT_ROW` to use with `JpaWindow`s.
`SqmWindowFrame`	`frameUnboundedFollowing()`	Create a window frame of type `FrameKind.UNBOUNDED_FOLLOWING` to use with `JpaWindow`s.
`SqmWindowFrame`	`frameUnboundedPreceding()`	Create a window frame of type `FrameKind.UNBOUNDED_PRECEDING` to use with `JpaWindow`s.
`<T> SqmFunction<T>`	`function(String name, Class<T> type, Expression<?>[] args)`
`<T> SqmExpression<T>`	`functionAggregate(String name, Class<T> type, JpaPredicate filter, Expression<?>... args)`
`<T> SqmExpression<T>`	`functionAggregate(String name, Class<T> type, JpaPredicate filter, JpaWindow window, Expression<?>... args)`	Create a generic aggregate function expression.
`<T> SqmExpression<T>`	`functionAggregate(String name, Class<T> type, JpaWindow window, Expression<?>... args)`
`<T> SqmExpression<T>`	`functionWithinGroup(String name, Class<T> type, JpaOrder order, Expression<?>... args)`
`<T> SqmExpression<T>`	`functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, Expression<?>... args)`
`<T> SqmExpression<T>`	`functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... args)`	Create a generic ordered set-aggregate function expression.
`<T> SqmExpression<T>`	`functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaWindow window, Expression<?>... args)`
`SqmPredicate`	`ge(Expression<? extends Number> x, Expression<? extends Number> y)`
`SqmPredicate`	`ge(Expression<? extends Number> x, Number y)`
`BasicType<Boolean>`	`getBooleanType()`
`BasicType<Character>`	`getCharacterType()`
`JpaMetamodel`	`getDomainModel()`
`BasicType<Integer>`	`getIntegerType()`
`JpaMetamodelImplementor`	`getJpaMetamodel()`	Access to the domain model metadata
`QueryEngine`	`getQueryEngine()`
`ServiceRegistry`	`getServiceRegistry()`	Access to the ServiceRegistry for the context
`SessionFactoryImplementor`	`getSessionFactory()`
`TypeConfiguration`	`getTypeConfiguration()`
`<Y extends Comparable<? super Y>> SqmPredicate`	`greaterThan(Expression<? extends Y> x, Expression<? extends Y> y)`
`<Y extends Comparable<? super Y>> SqmPredicate`	`greaterThan(Expression<? extends Y> x, Y y)`
`<Y extends Comparable<? super Y>> SqmPredicate`	`greaterThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)`
`<Y extends Comparable<? super Y>> SqmPredicate`	`greaterThanOrEqualTo(Expression<? extends Y> x, Y y)`
`<X extends Comparable<? super X>> SqmExpression<X>`	`greatest(Expression<X> argument)`
`SqmPredicate`	`gt(Expression<? extends Number> x, Expression<? extends Number> y)`
`SqmPredicate`	`gt(Expression<? extends Number> x, Number y)`
`SqmFunction<Integer>`	`hour(Expression<? extends TemporalAccessor> datetime)`	Extracts the `TemporalUnit.HOUR` of a date, time, or datetime expression.
`SqmPredicate`	`ilike(Expression<String> searchString, Expression<String> pattern)`
`SqmPredicate`	`ilike(Expression<String> searchString, Expression<String> pattern, char escapeChar)`
`SqmPredicate`	`ilike(Expression<String> searchString, Expression<String> pattern, Expression<Character> escapeChar)`
`SqmPredicate`	`ilike(Expression<String> searchString, String pattern)`
`SqmPredicate`	`ilike(Expression<String> searchString, String pattern, char escapeChar)`
`SqmPredicate`	`ilike(Expression<String> searchString, String pattern, Expression<Character> escapeChar)`
`<T> SqmInPredicate<T>`	`in(Expression<? extends T> expression)`
`<T> SqmInPredicate<T>`	`in(Expression<? extends T> expression, Expression<? extends T>... values)`
`<T> SqmInPredicate<T>`	`in(Expression<? extends T> expression, Collection<T> values)`
`<T> SqmInPredicate<T>`	`in(Expression<? extends T> expression, SqmSubQuery<T> subQuery)`
`<T> SqmInPredicate<T>`	`in(Expression<? extends T> expression, T... values)`
`<K,L extends List<?>> SqmExpression<Set<K>>`	`indexes(L list)`
`<T> JpaCriteriaQuery<T>`	`intersect(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)`
`<T> JpaSubQuery<T>`	`intersect(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)`
`<C extends Collection<?>> SqmPredicate`	`isEmpty(Expression<C> collection)`
`SqmPredicate`	`isFalse(Expression<Boolean> x)`
`boolean`	`isJpaQueryComplianceEnabled()`
`<M extends Map<?,?>> SqmPredicate`	`isMapEmpty(JpaExpression<M> mapExpression)`	Create a predicate that tests whether a Map is empty.
`<M extends Map<?,?>> SqmPredicate`	`isMapNotEmpty(JpaExpression<M> mapExpression)`	Create a predicate that tests whether a Map is not empty.
`<E,C extends Collection<E>> SqmPredicate`	`isMember(E elem, Expression<C> collection)`
`<E,C extends Collection<E>> SqmPredicate`	`isMember(Expression<E> elem, Expression<C> collection)`
`<C extends Collection<?>> SqmPredicate`	`isNotEmpty(Expression<C> collection)`
`<E,C extends Collection<E>> SqmPredicate`	`isNotMember(E elem, Expression<C> collection)`
`<E,C extends Collection<E>> SqmPredicate`	`isNotMember(Expression<E> elem, Expression<C> collection)`
`SqmPredicate`	`isNotNull(Expression<?> x)`
`SqmPredicate`	`isNull(Expression<?> x)`
`SqmPredicate`	`isTrue(Expression<Boolean> x)`
`<K,M extends Map<K,?>> SqmExpression<Set<K>>`	`keys(M map)`
`<T> SqmExpression<T>`	`lastValue(Expression<T> argument, JpaWindow window)`	Create a `last_value` window function expression.
`SqmPredicate`	`le(Expression<? extends Number> x, Expression<? extends Number> y)`
`SqmPredicate`	`le(Expression<? extends Number> x, Number y)`
`<X extends Comparable<? super X>> SqmExpression<X>`	`least(Expression<X> argument)`
`SqmFunction<String>`	`left(Expression<String> x, int length)`
`SqmFunction<String>`	`left(Expression<String> x, Expression<Integer> length)`	Extract the `length` leftmost characters of a string.
`SqmFunction<Integer>`	`length(Expression<String> argument)`
`<Y extends Comparable<? super Y>> SqmPredicate`	`lessThan(Expression<? extends Y> x, Expression<? extends Y> y)`
`<Y extends Comparable<? super Y>> SqmPredicate`	`lessThan(Expression<? extends Y> x, Y y)`
`<Y extends Comparable<? super Y>> SqmPredicate`	`lessThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)`
`<Y extends Comparable<? super Y>> SqmPredicate`	`lessThanOrEqualTo(Expression<? extends Y> x, Y y)`
`SqmPredicate`	`like(Expression<String> searchString, Expression<String> pattern)`
`SqmPredicate`	`like(Expression<String> searchString, Expression<String> pattern, char escapeChar)`
`SqmPredicate`	`like(Expression<String> searchString, Expression<String> pattern, Expression<Character> escapeChar)`
`SqmPredicate`	`like(Expression<String> searchString, String pattern)`
`SqmPredicate`	`like(Expression<String> searchString, String pattern, char escapeChar)`
`SqmPredicate`	`like(Expression<String> searchString, String pattern, Expression<Character> escapeChar)`
`SqmExpression<String>`	`listagg(JpaOrder order, Expression<String> argument, Expression<String> separator)`
`SqmExpression<String>`	`listagg(JpaOrder order, Expression<String> argument, String separator)`
`SqmExpression<String>`	`listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, Expression<String> separator)`
`SqmExpression<String>`	`listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, String separator)`
`SqmExpression<String>`	`listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, Expression<String> separator)`	Create a `listagg` ordered set-aggregate function expression.
`SqmExpression<String>`	`listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, String separator)`
`SqmExpression<String>`	`listagg(JpaOrder order, JpaWindow window, Expression<String> argument, Expression<String> separator)`
`SqmExpression<String>`	`listagg(JpaOrder order, JpaWindow window, Expression<String> argument, String separator)`
`<T> SqmLiteral<T>`	`literal(T value)`
`<T> SqmLiteral<T>`	`literal(T value, SqmExpression<? extends T> typeInferenceSource)`
`<T> List<? extends SqmExpression<T>>`	`literals(List<T> values)`
`<T> List<? extends SqmExpression<T>>`	`literals(T[] values)`
`JpaExpression<Double>`	`ln(Expression<? extends Number> x)`	Create an expression that returns the natural logarithm of its argument.
`JpaExpression<LocalDate>`	`localDate()`	Create expression to return current local date.
`JpaExpression<LocalDateTime>`	`localDateTime()`	Create expression to return current local datetime.
`JpaExpression<LocalTime>`	`localTime()`	Create expression to return current local time.
`SqmFunction<Integer>`	`locate(Expression<String> source, Expression<String> pattern)`
`SqmFunction<Integer>`	`locate(Expression<String> source, Expression<String> pattern, Expression<Integer> startPosition)`
`SqmFunction<Integer>`	`locate(Expression<String> source, String pattern)`
`SqmFunction<Integer>`	`locate(Expression<String> source, String pattern, int startPosition)`
`SqmFunction<Double>`	`log(Expression<? extends Number> b, Expression<? extends Number> x)`	Create an expression that returns the logarithm of `x` to the base `b`.
`SqmFunction<Double>`	`log(Number b, Expression<? extends Number> x)`
`SqmFunction<Double>`	`log10(Expression<? extends Number> x)`	Create an expression that returns the base-10 logarithm of its argument.
`SqmFunction<String>`	`lower(Expression<String> x)`
`SqmPredicate`	`lt(Expression<? extends Number> x, Expression<? extends Number> y)`
`SqmPredicate`	`lt(Expression<? extends Number> x, Number y)`
`<M extends Map<?,?>> SqmExpression<Integer>`	`mapSize(M map)`	Create an expression that tests the size of a map.
`<M extends Map<?,?>> SqmExpression<Integer>`	`mapSize(JpaExpression<M> mapExpression)`	Create an expression that tests the size of a map.
`<N extends Number> SqmExpression<N>`	`max(Expression<N> argument)`
`<N extends Number> SqmExpression<N>`	`min(Expression<N> argument)`
`SqmFunction<Integer>`	`minute(Expression<? extends TemporalAccessor> datetime)`	Extracts the `TemporalUnit.MINUTE` of a date, time, or datetime expression.
`SqmExpression<Integer>`	`mod(Expression<Integer> x, Expression<Integer> y)`
`SqmExpression<Integer>`	`mod(Expression<Integer> x, Integer y)`
`SqmExpression<Integer>`	`mod(Integer x, Expression<Integer> y)`
`<T> SqmExpression<T>`	`mode(Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> SqmExpression<T>`	`mode(JpaPredicate filter, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> SqmExpression<T>`	`mode(JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`	Create a `mode` ordered set-aggregate function expression.
`<T> SqmExpression<T>`	`mode(JpaWindow window, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`SqmFunction<Integer>`	`month(Expression<? extends TemporalAccessor> datetime)`	Extracts the `TemporalUnit.MONTH` of a date, time, or datetime expression.
`<N extends Number> SqmExpression<N>`	`neg(Expression<N> x)`
`SqmPredicate`	`not(Expression<Boolean> restriction)`
`SqmPredicate`	`notDistinctFrom(Expression<?> x, Expression<?> y)`
`SqmPredicate`	`notDistinctFrom(Expression<?> x, Object y)`
`SqmPredicate`	`notEqual(Expression<?> x, Expression<?> y)`
`SqmPredicate`	`notEqual(Expression<?> x, Object y)`
`SqmPredicate`	`notIlike(Expression<String> x, Expression<String> pattern)`
`SqmPredicate`	`notIlike(Expression<String> x, Expression<String> pattern, char escapeChar)`
`SqmPredicate`	`notIlike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)`
`SqmPredicate`	`notIlike(Expression<String> x, String pattern)`
`SqmPredicate`	`notIlike(Expression<String> x, String pattern, char escapeChar)`
`SqmPredicate`	`notIlike(Expression<String> x, String pattern, Expression<Character> escapeChar)`
`SqmPredicate`	`notLike(Expression<String> x, Expression<String> pattern)`
`SqmPredicate`	`notLike(Expression<String> x, Expression<String> pattern, char escapeChar)`
`SqmPredicate`	`notLike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)`
`SqmPredicate`	`notLike(Expression<String> x, String pattern)`
`SqmPredicate`	`notLike(Expression<String> x, String pattern, char escapeChar)`
`SqmPredicate`	`notLike(Expression<String> x, String pattern, Expression<Character> escapeChar)`
`<T> SqmExpression<T>`	`nthValue(Expression<T> argument, int n, JpaWindow window)`
`<T> SqmExpression<T>`	`nthValue(Expression<T> argument, Expression<Integer> n, JpaWindow window)`	Create a `nth_value` window function expression.
`<Y> SqmExpression<Y>`	`nullif(Expression<Y> x, Expression<?> y)`
`<Y> SqmExpression<Y>`	`nullif(Expression<Y> x, Y y)`
`<T> SqmExpression<T>`	`nullLiteral(Class<T> resultClass)`
`SqmPredicate`	`or(Expression<Boolean> x, Expression<Boolean> y)`
`SqmPredicate`	`or(Predicate... restrictions)`
`SqmFunction<String>`	`overlay(Expression<String> string, Expression<String> replacement, int start)`
`SqmFunction<String>`	`overlay(Expression<String> string, Expression<String> replacement, int start, int length)`
`SqmFunction<String>`	`overlay(Expression<String> string, Expression<String> replacement, int start, Expression<Integer> length)`
`SqmFunction<String>`	`overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start)`
`SqmFunction<String>`	`overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start, int length)`
`SqmFunction<String>`	`overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start, Expression<Integer> length)`	Overlay the `string` expression with the `replacement` expression, starting from index `start` and substituting a number of characters corresponding to the length of the `replacement` expression or the `length` parameter if specified.
`SqmFunction<String>`	`overlay(Expression<String> string, String replacement, int start)`
`SqmFunction<String>`	`overlay(Expression<String> string, String replacement, int start, int length)`
`SqmFunction<String>`	`overlay(Expression<String> string, String replacement, int start, Expression<Integer> length)`
`SqmFunction<String>`	`overlay(Expression<String> string, String replacement, Expression<Integer> start)`
`SqmFunction<String>`	`overlay(Expression<String> string, String replacement, Expression<Integer> start, int length)`
`SqmFunction<String>`	`overlay(Expression<String> string, String replacement, Expression<Integer> start, Expression<Integer> length)`
`SqmFunction<String>`	`pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length)`
`SqmFunction<String>`	`pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length, char padChar)`
`SqmFunction<String>`	`pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length, Expression<Character> padChar)`
`SqmFunction<String>`	`pad(CriteriaBuilder.Trimspec ts, Expression<String> x, Expression<Integer> length)`
`SqmFunction<String>`	`pad(CriteriaBuilder.Trimspec ts, Expression<String> x, Expression<Integer> length, char padChar)`
`SqmFunction<String>`	`pad(CriteriaBuilder.Trimspec ts, Expression<String> x, Expression<Integer> length, Expression<Character> padChar)`	Pad the specified string expression with whitespace or with the `padChar` character if specified.
`SqmFunction<String>`	`pad(Expression<String> x, int length)`
`SqmFunction<String>`	`pad(Expression<String> x, int length, char padChar)`
`SqmFunction<String>`	`pad(Expression<String> x, int length, Expression<Character> padChar)`
`SqmFunction<String>`	`pad(Expression<String> x, Expression<Integer> length)`
`SqmFunction<String>`	`pad(Expression<String> x, Expression<Integer> length, char padChar)`
`SqmFunction<String>`	`pad(Expression<String> x, Expression<Integer> length, Expression<Character> padChar)`
`<T> JpaCriteriaParameter<T>`	`parameter(Class<T> paramClass)`
`<T> JpaCriteriaParameter<T>`	`parameter(Class<T> paramClass, String name)`
`<T> SqmExpression<T>`	`percentileCont(Expression<? extends Number> argument, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> SqmExpression<T>`	`percentileCont(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> SqmExpression<T>`	`percentileCont(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`	Create a `percentile_cont` ordered set-aggregate function expression.
`<T> SqmExpression<T>`	`percentileCont(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> SqmExpression<T>`	`percentileDisc(Expression<? extends Number> argument, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> SqmExpression<T>`	`percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> SqmExpression<T>`	`percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`	Create a `percentile_disc` ordered set-aggregate function expression.
`<T> SqmExpression<T>`	`percentileDisc(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`SqmExpression<Double>`	`percentRank(JpaOrder order, Expression<?>... arguments)`
`SqmExpression<Double>`	`percentRank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)`
`SqmExpression<Double>`	`percentRank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)`	Create a `percent_rank` ordered set-aggregate function expression.
`SqmExpression<Double>`	`percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments)`
`SqmExpression<Double>`	`percentRank(JpaWindow window)`	Create a `percent_rank` window function expression.
`SqmFunction<Double>`	`pi()`	Literal expression corresponding to the value of pi.
`JpaExpression<Double>`	`power(Expression<? extends Number> x, Expression<? extends Number> y)`	Create an expression that returns the first argument raised to the power of its second argument.
`JpaExpression<Double>`	`power(Expression<? extends Number> x, Number y)`	Create an expression that returns the first argument raised to the power of its second argument.
`<N extends Number> SqmExpression<N>`	`prod(Expression<? extends N> x, Expression<? extends N> y)`
`<N extends Number> SqmExpression<N>`	`prod(Expression<? extends N> x, N y)`
`<N extends Number> SqmExpression<N>`	`prod(N x, Expression<? extends N> y)`
`SqmExpression<Number>`	`quot(Expression<? extends Number> x, Expression<? extends Number> y)`
`SqmExpression<Number>`	`quot(Expression<? extends Number> x, Number y)`
`SqmExpression<Number>`	`quot(Number x, Expression<? extends Number> y)`
`SqmFunction<Double>`	`radians(Expression<? extends Number> x)`	Create an expression that converts an angle measured in degrees to an approximately equivalent angle measured in radians.
`SqmExpression<Long>`	`rank(JpaOrder order, Expression<?>... arguments)`
`SqmExpression<Long>`	`rank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)`
`SqmExpression<Long>`	`rank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)`	Create a `rank` ordered set-aggregate function expression.
`SqmExpression<Long>`	`rank(JpaOrder order, JpaWindow window, Expression<?>... arguments)`
`SqmExpression<Long>`	`rank(JpaWindow window)`	Create a `rank` window function expression.
`SqmFunction<String>`	`replace(Expression<String> x, Expression<String> pattern, Expression<String> replacement)`	Replace all occurrences of `pattern` within the original string with `replacement`.
`SqmFunction<String>`	`replace(Expression<String> x, Expression<String> pattern, String replacement)`
`SqmFunction<String>`	`replace(Expression<String> x, String pattern, Expression<String> replacement)`
`SqmFunction<String>`	`replace(Expression<String> x, String pattern, String replacement)`
`SqmFunction<String>`	`right(Expression<String> x, int length)`
`SqmFunction<String>`	`right(Expression<String> x, Expression<Integer> length)`	Extract the `length` rightmost characters of a string.
`<T extends Number> JpaExpression<T>`	`round(Expression<T> x, Integer n)`	Create an expression that returns the first argument rounded to the number of decimal places given by the second argument.
`SqmExpression<Long>`	`rowNumber(JpaWindow window)`	Create a `row_number` window function expression.
`JpaSearchOrder`	`search(JpaCteCriteriaAttribute sortExpression)`	Create a search ordering based on the ascending value of the CTE attribute.
`JpaSearchOrder`	`search(JpaCteCriteriaAttribute sortExpression, SortOrder sortOrder)`	Create a search ordering based on the sort order of the value of the CTE attribute.
`JpaSearchOrder`	`search(JpaCteCriteriaAttribute sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`	Create a search ordering based on the sort order and null precedence of the value of the CTE attribute.
`SqmFunction<Float>`	`second(Expression<? extends TemporalAccessor> datetime)`	Extracts the `TemporalUnit.SECOND` of a date, time, or datetime expression.
`<R> SqmCaseSearched<R>`	`selectCase()`
`<C,R> SqmCaseSimple<C,R>`	`selectCase(Expression<? extends C> expression)`
`JpaExpression<Integer>`	`sign(Expression<? extends Number> x)`	Create an expression that returns the sign of its argument, that is, `1` if its argument is positive, `-1` if its argument is negative, or `0` if its argument is exactly zero.
`SqmFunction<Double>`	`sin(Expression<? extends Number> x)`	Create an expression that returns the sine of its argument.
`SqmFunction<Double>`	`sinh(Expression<? extends Number> x)`	Create an expression that returns the hyperbolic sine of its argument.
`<C extends Collection<?>> SqmExpression<Integer>`	`size(C collection)`
`<C extends Collection<?>> SqmExpression<Integer>`	`size(Expression<C> collection)`
`<Y> SqmModifiedSubQueryExpression<Y>`	`some(Subquery<Y> subquery)`
`SqmSortSpecification`	`sort(JpaExpression<?> sortExpression)`
`SqmSortSpecification`	`sort(JpaExpression<?> sortExpression, SortOrder sortOrder)`
`SqmSortSpecification`	`sort(JpaExpression<?> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> SqmFunction<T>`	`sql(String pattern, Class<T> type, Expression<?>... arguments)`	Embed native `pattern` that will be unquoted and embedded in the generated SQL.
`SqmExpression<Double>`	`sqrt(Expression<? extends Number> x)`
`SqmFunction<String>`	`substring(Expression<String> source, int from)`
`SqmFunction<String>`	`substring(Expression<String> source, int from, int len)`
`SqmFunction<String>`	`substring(Expression<String> source, Expression<Integer> from)`
`SqmFunction<String>`	`substring(Expression<String> source, Expression<Integer> from, Expression<Integer> len)`
`<N extends Number> SqmExpression<N>`	`sum(Expression<? extends N> x, Expression<? extends N> y)`
`<N extends Number> SqmExpression<N>`	`sum(Expression<? extends N> x, N y)`
`<N extends Number> SqmExpression<N>`	`sum(Expression<N> argument)`
`<N extends Number> SqmExpression<Number>`	`sum(Expression<N> argument, JpaPredicate filter)`
`<N extends Number> SqmExpression<Number>`	`sum(Expression<N> argument, JpaPredicate filter, JpaWindow window)`	Create a `sum` aggregate function expression.
`<N extends Number> SqmExpression<Number>`	`sum(Expression<N> argument, JpaWindow window)`
`<N extends Number> SqmExpression<N>`	`sum(N x, Expression<? extends N> y)`
`SqmExpression<Double>`	`sumAsDouble(Expression<Float> argument)`
`SqmExpression<Long>`	`sumAsLong(Expression<Integer> argument)`
`SqmFunction<Double>`	`tan(Expression<? extends Number> x)`	Create an expression that returns the tangent of its argument.
`SqmFunction<Double>`	`tanh(Expression<? extends Number> x)`	Create an expression that returns the hyperbolic tangent of its argument.
`SqmExpression<BigDecimal>`	`toBigDecimal(Expression<? extends Number> number)`
`SqmExpression<BigInteger>`	`toBigInteger(Expression<? extends Number> number)`
`SqmExpression<Double>`	`toDouble(Expression<? extends Number> number)`
`SqmExpression<Float>`	`toFloat(Expression<? extends Number> number)`
`SqmExpression<Integer>`	`toInteger(Expression<? extends Number> number)`
`SqmExpression<Long>`	`toLong(Expression<? extends Number> number)`
`SqmExpression<String>`	`toString(Expression<Character> character)`
`<X,T,E extends T> SqmBagJoin<X,E>`	`treat(CollectionJoin<X,T> join, Class<E> type)`
`<X,T,V extends T> SqmSingularJoin<X,V>`	`treat(Join<X,T> join, Class<V> type)`
`<X,T,E extends T> SqmListJoin<X,E>`	`treat(ListJoin<X,T> join, Class<E> type)`
`<X,K,T,V extends T> SqmMapJoin<X,K,V>`	`treat(MapJoin<X,K,T> join, Class<V> type)`
`<X,T extends X> SqmPath<T>`	`treat(Path<X> path, Class<T> type)`
`<X,T extends X> SqmRoot<T>`	`treat(Root<X> root, Class<T> type)`
`<X,T,E extends T> SqmSetJoin<X,E>`	`treat(SetJoin<X,T> join, Class<E> type)`
`SqmFunction<String>`	`trim(char trimChar, Expression<String> source)`
`SqmFunction<String>`	`trim(CriteriaBuilder.Trimspec ts, char trimChar, Expression<String> source)`
`SqmFunction<String>`	`trim(CriteriaBuilder.Trimspec ts, Expression<Character> trimChar, Expression<String> source)`
`SqmFunction<String>`	`trim(CriteriaBuilder.Trimspec ts, Expression<String> source)`
`SqmFunction<String>`	`trim(Expression<Character> trimChar, Expression<String> source)`
`SqmFunction<String>`	`trim(Expression<String> source)`
`<T extends Number> JpaExpression<T>`	`truncate(Expression<T> x, Integer n)`	Create an expression that returns the first argument truncated to the number of decimal places given by the second argument.
`<T extends TemporalAccessor> SqmFunction<T>`	`truncate(Expression<T> datetime, TemporalUnit temporalUnit)`	Truncates a date, time or datetime expression to the given `TemporalUnit`.
`JpaCompoundSelection<Tuple>`	`tuple(Selection<?>[] selections)`
`<R> SqmTuple<R>`	`tuple(Class<R> tupleType, List<? extends SqmExpression<?>> expressions)`
`<R> SqmTuple<R>`	`tuple(Class<R> tupleType, SqmExpression<?>... expressions)`
`JpaCompoundSelection<Tuple>`	`tuple(List<? extends JpaSelection<?>> selections)`
`<R> SqmTuple<R>`	`tuple(SqmExpressible<R> tupleType, List<? extends SqmExpression<?>> sqmExpressions)`
`<R> SqmTuple<R>`	`tuple(SqmExpressible<R> tupleType, SqmExpression<?>... expressions)`
`<T> JpaCriteriaQuery<T>`	`union(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)`
`<T> JpaSubQuery<T>`	`union(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)`
`<T extends HibernateCriteriaBuilder> T`	`unwrap(Class<T> clazz)`
`SqmFunction<String>`	`upper(Expression<String> x)`
`<T> SqmExpression<T>`	`value(T value)`
`<T> SqmExpression<T>`	`value(T value, SqmExpression<? extends T> typeInferenceSource)`	Creates an expression for the value with the given "type inference" information
`<V,C extends Collection<V>> SqmExpression<Collection<V>>`	`values(C collection)`
`<V,M extends Map<?,V>> Expression<Collection<V>>`	`values(M map)`
`<T> SqmExpression<T>`	`windowFunction(String name, Class<T> type, JpaWindow window, Expression<?>... args)`	Create a generic window function expression that will be applied over the specified `window`.
`SqmPredicate`	`wrap(Expression<Boolean> expression)`
`SqmPredicate`	`wrap(Expression<Boolean>... expressions)`
`SqmFunction<Integer>`	`year(Expression<? extends TemporalAccessor> datetime)`	Extracts the `TemporalUnit.YEAR` of a date, time, or datetime expression.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.hibernate.query.criteria.HibernateCriteriaBuilder
except, except, exceptAll, exceptAll, intersect, intersect, intersectAll, intersectAll, union, union, unionAll, unionAll

Methods inherited from interface org.hibernate.query.sqm.spi.SqmCreationContext
getNodeBuilder

- Constructor Detail
  - SqmCriteriaNodeBuilder
```
public SqmCriteriaNodeBuilder(String uuid,
                              String name,
                              QueryEngine queryEngine,
                              boolean jpaComplianceEnabled,
                              ValueHandlingMode criteriaValueHandlingMode,
                              ServiceRegistry serviceRegistry,
                              Supplier<SessionFactoryImplementor> sessionFactory)
```
- Method Detail
  - getDomainModel
```
public JpaMetamodel getDomainModel()
```
    Specified by:
    
    getDomainModel in interface NodeBuilder
  - getTypeConfiguration
```
public TypeConfiguration getTypeConfiguration()
```
    Specified by:
    
    getTypeConfiguration in interface NodeBuilder
  - isJpaQueryComplianceEnabled
```
public boolean isJpaQueryComplianceEnabled()
```
    Specified by:
    
    isJpaQueryComplianceEnabled in interface NodeBuilder
  - getSessionFactory
```
public SessionFactoryImplementor getSessionFactory()
```
    Specified by:
    
    getSessionFactory in interface NodeBuilder
  - areTypesComparable
```
public static boolean areTypesComparable(SqmExpressible<?> lhsType,
                                         SqmExpressible<?> rhsType)
```
  - getBooleanType
```
public BasicType<Boolean> getBooleanType()
```
    Specified by:
    
    getBooleanType in interface NodeBuilder
  - getIntegerType
```
public BasicType<Integer> getIntegerType()
```
    Specified by:
    
    getIntegerType in interface NodeBuilder
  - getCharacterType
```
public BasicType<Character> getCharacterType()
```
    Specified by:
    
    getCharacterType in interface NodeBuilder
  - getServiceRegistry
```
public ServiceRegistry getServiceRegistry()
```
    Description copied from interface: SqmCreationContext
    
    Access to the ServiceRegistry for the context
    
    Specified by:
    
    getServiceRegistry in interface NodeBuilder
    
    Specified by:
    
    getServiceRegistry in interface SqmCreationContext
  - getQueryEngine
```
public QueryEngine getQueryEngine()
```
    Specified by:
    
    getQueryEngine in interface NodeBuilder
    
    Specified by:
    
    getQueryEngine in interface SqmCreationContext
  - getJpaMetamodel
```
public JpaMetamodelImplementor getJpaMetamodel()
```
    Description copied from interface: SqmCreationContext
    
    Access to the domain model metadata
    
    Specified by:
    
    getJpaMetamodel in interface SqmCreationContext
  - close
```
public void close()
```
  - createQuery
```
public SqmSelectStatement<Object> createQuery()
```
    Specified by:
    
    createQuery in interface CriteriaBuilder
    
    Specified by:
    
    createQuery in interface HibernateCriteriaBuilder
    
    Specified by:
    
    createQuery in interface NodeBuilder
  - createQuery
```
public <T> SqmSelectStatement<T> createQuery(Class<T> resultClass)
```
    Specified by:
    
    createQuery in interface CriteriaBuilder
    
    Specified by:
    
    createQuery in interface HibernateCriteriaBuilder
    
    Specified by:
    
    createQuery in interface NodeBuilder
  - createTupleQuery
```
public SqmSelectStatement<Tuple> createTupleQuery()
```
    Specified by:
    
    createTupleQuery in interface CriteriaBuilder
    
    Specified by:
    
    createTupleQuery in interface HibernateCriteriaBuilder
    
    Specified by:
    
    createTupleQuery in interface NodeBuilder
  - createCriteriaUpdate
```
public <T> SqmUpdateStatement<T> createCriteriaUpdate(Class<T> targetEntity)
```
    Specified by:
    
    createCriteriaUpdate in interface CriteriaBuilder
    
    Specified by:
    
    createCriteriaUpdate in interface HibernateCriteriaBuilder
    
    Specified by:
    
    createCriteriaUpdate in interface NodeBuilder
  - createCriteriaDelete
```
public <T> SqmDeleteStatement<T> createCriteriaDelete(Class<T> targetEntity)
```
    Specified by:
    
    createCriteriaDelete in interface CriteriaBuilder
    
    Specified by:
    
    createCriteriaDelete in interface HibernateCriteriaBuilder
    
    Specified by:
    
    createCriteriaDelete in interface NodeBuilder
  - createCriteriaInsertSelect
```
public <T> SqmInsertSelectStatement<T> createCriteriaInsertSelect(Class<T> targetEntity)
```
    Specified by:
    
    createCriteriaInsertSelect in interface HibernateCriteriaBuilder
    
    Specified by:
    
    createCriteriaInsertSelect in interface NodeBuilder
  - union
```
public <T> JpaCriteriaQuery<T> union(boolean all,
                                     CriteriaQuery<? extends T> query1,
                                     CriteriaQuery<?>... queries)
```
    Specified by:
    
    union in interface HibernateCriteriaBuilder
  - intersect
```
public <T> JpaCriteriaQuery<T> intersect(boolean all,
                                         CriteriaQuery<? extends T> query1,
                                         CriteriaQuery<?>... queries)
```
    Specified by:
    
    intersect in interface HibernateCriteriaBuilder
  - except
```
public <T> JpaCriteriaQuery<T> except(boolean all,
                                      CriteriaQuery<? extends T> query1,
                                      CriteriaQuery<?>... queries)
```
    Specified by:
    
    except in interface HibernateCriteriaBuilder
  - union
```
public <T> JpaSubQuery<T> union(boolean all,
                                Subquery<? extends T> query1,
                                Subquery<?>... queries)
```
    Specified by:
    
    union in interface HibernateCriteriaBuilder
  - intersect
```
public <T> JpaSubQuery<T> intersect(boolean all,
                                    Subquery<? extends T> query1,
                                    Subquery<?>... queries)
```
    Specified by:
    
    intersect in interface HibernateCriteriaBuilder
  - except
```
public <T> JpaSubQuery<T> except(boolean all,
                                 Subquery<? extends T> query1,
                                 Subquery<?>... queries)
```
    Specified by:
    
    except in interface HibernateCriteriaBuilder
  - cast
```
public <X,T> SqmExpression<X> cast(JpaExpression<T> expression,
                                         Class<X> castTargetJavaType)
```
    Specified by:
    
    cast in interface HibernateCriteriaBuilder
    
    Specified by:
    
    cast in interface NodeBuilder
  - wrap
```
public SqmPredicate wrap(Expression<Boolean> expression)
```
    Specified by:
    
    wrap in interface HibernateCriteriaBuilder
    
    Specified by:
    
    wrap in interface NodeBuilder
  - wrap
```
@SafeVarargs
public final SqmPredicate wrap(Expression<Boolean>... expressions)
```
    Specified by:
    
    wrap in interface HibernateCriteriaBuilder
    
    Specified by:
    
    wrap in interface NodeBuilder
  - unwrap
```
public <T extends HibernateCriteriaBuilder> T unwrap(Class<T> clazz)
```
    Specified by:
    
    unwrap in interface HibernateCriteriaBuilder
  - fk
```
public <P,F> SqmExpression<F> fk(Path<P> path)
```
    Specified by:
    
    fk in interface HibernateCriteriaBuilder
    
    Specified by:
    
    fk in interface NodeBuilder
  - treat
```
public <X,T extends X> SqmPath<T> treat(Path<X> path,
                                              Class<T> type)
```
    Specified by:
    
    treat in interface CriteriaBuilder
    
    Specified by:
    
    treat in interface HibernateCriteriaBuilder
    
    Specified by:
    
    treat in interface NodeBuilder
  - treat
```
public <X,T extends X> SqmRoot<T> treat(Root<X> root,
                                              Class<T> type)
```
    Specified by:
    
    treat in interface CriteriaBuilder
    
    Specified by:
    
    treat in interface HibernateCriteriaBuilder
    
    Specified by:
    
    treat in interface NodeBuilder
  - treat
```
public <X,T,V extends T> SqmSingularJoin<X,V> treat(Join<X,T> join,
                                                                      Class<V> type)
```
    Specified by:
    
    treat in interface CriteriaBuilder
    
    Specified by:
    
    treat in interface HibernateCriteriaBuilder
    
    Specified by:
    
    treat in interface NodeBuilder
  - treat
```
public <X,T,E extends T> SqmBagJoin<X,E> treat(CollectionJoin<X,T> join,
                                                                 Class<E> type)
```
    Specified by:
    
    treat in interface CriteriaBuilder
    
    Specified by:
    
    treat in interface HibernateCriteriaBuilder
    
    Specified by:
    
    treat in interface NodeBuilder
  - treat
```
public <X,T,E extends T> SqmSetJoin<X,E> treat(SetJoin<X,T> join,
                                                                 Class<E> type)
```
    Specified by:
    
    treat in interface CriteriaBuilder
    
    Specified by:
    
    treat in interface HibernateCriteriaBuilder
    
    Specified by:
    
    treat in interface NodeBuilder
  - treat
```
public <X,T,E extends T> SqmListJoin<X,E> treat(ListJoin<X,T> join,
                                                                  Class<E> type)
```
    Specified by:
    
    treat in interface CriteriaBuilder
    
    Specified by:
    
    treat in interface HibernateCriteriaBuilder
    
    Specified by:
    
    treat in interface NodeBuilder
  - treat
```
public <X,K,T,V extends T> SqmMapJoin<X,K,V> treat(MapJoin<X,K,T> join,
                                                                                 Class<V> type)
```
    Specified by:
    
    treat in interface CriteriaBuilder
    
    Specified by:
    
    treat in interface HibernateCriteriaBuilder
    
    Specified by:
    
    treat in interface NodeBuilder
  - sort
```
public SqmSortSpecification sort(JpaExpression<?> sortExpression,
                                 SortOrder sortOrder,
                                 NullPrecedence nullPrecedence)
```
    Specified by:
    
    sort in interface HibernateCriteriaBuilder
    
    Specified by:
    
    sort in interface NodeBuilder
  - sort
```
public SqmSortSpecification sort(JpaExpression<?> sortExpression,
                                 SortOrder sortOrder)
```
    Specified by:
    
    sort in interface HibernateCriteriaBuilder
    
    Specified by:
    
    sort in interface NodeBuilder
  - sort
```
public SqmSortSpecification sort(JpaExpression<?> sortExpression)
```
    Specified by:
    
    sort in interface HibernateCriteriaBuilder
    
    Specified by:
    
    sort in interface NodeBuilder
  - asc
```
public SqmSortSpecification asc(Expression<?> x)
```
    Specified by:
    
    asc in interface CriteriaBuilder
    
    Specified by:
    
    asc in interface HibernateCriteriaBuilder
    
    Specified by:
    
    asc in interface NodeBuilder
  - desc
```
public SqmSortSpecification desc(Expression<?> x)
```
    Specified by:
    
    desc in interface CriteriaBuilder
    
    Specified by:
    
    desc in interface HibernateCriteriaBuilder
    
    Specified by:
    
    desc in interface NodeBuilder
  - asc
```
public JpaOrder asc(Expression<?> x,
                    boolean nullsFirst)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an ordering by the ascending value of the expression.
    
    Specified by:
    
    asc in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression used to define the ordering
    
    nullsFirst - Whether null should be sorted first
    
    Returns:
    
    ascending ordering corresponding to the expression
  - desc
```
public JpaOrder desc(Expression<?> x,
                     boolean nullsFirst)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an ordering by the descending value of the expression.
    
    Specified by:
    
    desc in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression used to define the ordering
    
    nullsFirst - Whether null should be sorted first
    
    Returns:
    
    descending ordering corresponding to the expression
  - search
```
public JpaSearchOrder search(JpaCteCriteriaAttribute sortExpression,
                             SortOrder sortOrder,
                             NullPrecedence nullPrecedence)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a search ordering based on the sort order and null precedence of the value of the CTE attribute.
    
    Specified by:
    
    search in interface HibernateCriteriaBuilder
    
    Parameters:
    
    sortExpression - CTE attribute used to define the ordering
    
    sortOrder - The sort order
    
    nullPrecedence - The null precedence
    
    Returns:
    
    ordering corresponding to the CTE attribute
  - search
```
public JpaSearchOrder search(JpaCteCriteriaAttribute sortExpression,
                             SortOrder sortOrder)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a search ordering based on the sort order of the value of the CTE attribute.
    
    Specified by:
    
    search in interface HibernateCriteriaBuilder
    
    Parameters:
    
    sortExpression - CTE attribute used to define the ordering
    
    sortOrder - The sort order
    
    Returns:
    
    ordering corresponding to the CTE attribute
  - search
```
public JpaSearchOrder search(JpaCteCriteriaAttribute sortExpression)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a search ordering based on the ascending value of the CTE attribute.
    
    Specified by:
    
    search in interface HibernateCriteriaBuilder
    
    Parameters:
    
    sortExpression - CTE attribute used to define the ordering
    
    Returns:
    
    ascending ordering corresponding to the CTE attribute
  - asc
```
public JpaSearchOrder asc(JpaCteCriteriaAttribute x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a search ordering by the ascending value of the CTE attribute.
    
    Specified by:
    
    asc in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - CTE attribute used to define the ordering
    
    Returns:
    
    ascending ordering corresponding to the CTE attribute
  - desc
```
public JpaSearchOrder desc(JpaCteCriteriaAttribute x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a search ordering by the descending value of the CTE attribute.
    
    Specified by:
    
    desc in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - CTE attribute used to define the ordering
    
    Returns:
    
    descending ordering corresponding to the CTE attribute
  - asc
```
public JpaSearchOrder asc(JpaCteCriteriaAttribute x,
                          boolean nullsFirst)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a search ordering by the ascending value of the CTE attribute.
    
    Specified by:
    
    asc in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - CTE attribute used to define the ordering
    
    nullsFirst - Whether null should be sorted first
    
    Returns:
    
    ascending ordering corresponding to the CTE attribute
  - desc
```
public JpaSearchOrder desc(JpaCteCriteriaAttribute x,
                           boolean nullsFirst)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a search ordering by the descending value of the CTE attribute.
    
    Specified by:
    
    desc in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - CTE attribute used to define the ordering
    
    nullsFirst - Whether null should be sorted first
    
    Returns:
    
    descending ordering corresponding to the CTE attribute
  - tuple
```
public JpaCompoundSelection<Tuple> tuple(Selection<?>[] selections)
```
    Specified by:
    
    tuple in interface CriteriaBuilder
    
    Specified by:
    
    tuple in interface HibernateCriteriaBuilder
    
    Specified by:
    
    tuple in interface NodeBuilder
  - tuple
```
public JpaCompoundSelection<Tuple> tuple(List<? extends JpaSelection<?>> selections)
```
    Specified by:
    
    tuple in interface HibernateCriteriaBuilder
    
    Specified by:
    
    tuple in interface NodeBuilder
  - tuple
```
public <R> SqmTuple<R> tuple(Class<R> tupleType,
                             SqmExpression<?>... expressions)
```
    Specified by:
    
    tuple in interface NodeBuilder
  - tuple
```
public <R> SqmTuple<R> tuple(Class<R> tupleType,
                             List<? extends SqmExpression<?>> expressions)
```
    Specified by:
    
    tuple in interface NodeBuilder
  - tuple
```
public <R> SqmTuple<R> tuple(SqmExpressible<R> tupleType,
                             SqmExpression<?>... expressions)
```
    Specified by:
    
    tuple in interface NodeBuilder
  - tuple
```
public <R> SqmTuple<R> tuple(SqmExpressible<R> tupleType,
                             List<? extends SqmExpression<?>> sqmExpressions)
```
    Specified by:
    
    tuple in interface NodeBuilder
  - array
```
public JpaCompoundSelection<Object[]> array(Selection<?>[] selections)
```
    Specified by:
    
    array in interface CriteriaBuilder
    
    Specified by:
    
    array in interface HibernateCriteriaBuilder
    
    Specified by:
    
    array in interface NodeBuilder
  - array
```
public JpaCompoundSelection<Object[]> array(List<? extends JpaSelection<?>> selections)
```
    Specified by:
    
    array in interface HibernateCriteriaBuilder
    
    Specified by:
    
    array in interface NodeBuilder
  - array
```
public <Y> JpaCompoundSelection<Y> array(Class<Y> resultClass,
                                         Selection<?>[] selections)
```
    Specified by:
    
    array in interface HibernateCriteriaBuilder
  - array
```
public <Y> JpaCompoundSelection<Y> array(Class<Y> resultClass,
                                         List<? extends JpaSelection<?>> selections)
```
    Specified by:
    
    array in interface HibernateCriteriaBuilder
  - construct
```
public <Y> JpaCompoundSelection<Y> construct(Class<Y> resultClass,
                                             Selection<?>[] arguments)
```
    Specified by:
    
    construct in interface CriteriaBuilder
    
    Specified by:
    
    construct in interface HibernateCriteriaBuilder
    
    Specified by:
    
    construct in interface NodeBuilder
  - construct
```
public <Y> JpaCompoundSelection<Y> construct(Class<Y> resultClass,
                                             List<? extends JpaSelection<?>> arguments)
```
    Specified by:
    
    construct in interface HibernateCriteriaBuilder
    
    Specified by:
    
    construct in interface NodeBuilder
  - avg
```
public <N extends Number> SqmExpression<Double> avg(Expression<N> argument)
```
    Specified by:
    
    avg in interface CriteriaBuilder
    
    Specified by:
    
    avg in interface HibernateCriteriaBuilder
    
    Specified by:
    
    avg in interface NodeBuilder
  - sum
```
public <N extends Number> SqmExpression<N> sum(Expression<N> argument)
```
    Specified by:
    
    sum in interface CriteriaBuilder
    
    Specified by:
    
    sum in interface HibernateCriteriaBuilder
    
    Specified by:
    
    sum in interface NodeBuilder
  - sumAsLong
```
public SqmExpression<Long> sumAsLong(Expression<Integer> argument)
```
    Specified by:
    
    sumAsLong in interface CriteriaBuilder
    
    Specified by:
    
    sumAsLong in interface HibernateCriteriaBuilder
    
    Specified by:
    
    sumAsLong in interface NodeBuilder
  - sumAsDouble
```
public SqmExpression<Double> sumAsDouble(Expression<Float> argument)
```
    Specified by:
    
    sumAsDouble in interface CriteriaBuilder
    
    Specified by:
    
    sumAsDouble in interface HibernateCriteriaBuilder
    
    Specified by:
    
    sumAsDouble in interface NodeBuilder
  - max
```
public <N extends Number> SqmExpression<N> max(Expression<N> argument)
```
    Specified by:
    
    max in interface CriteriaBuilder
    
    Specified by:
    
    max in interface HibernateCriteriaBuilder
    
    Specified by:
    
    max in interface NodeBuilder
  - min
```
public <N extends Number> SqmExpression<N> min(Expression<N> argument)
```
    Specified by:
    
    min in interface CriteriaBuilder
    
    Specified by:
    
    min in interface HibernateCriteriaBuilder
    
    Specified by:
    
    min in interface NodeBuilder
  - greatest
```
public <X extends Comparable<? super X>> SqmExpression<X> greatest(Expression<X> argument)
```
    Specified by:
    
    greatest in interface CriteriaBuilder
    
    Specified by:
    
    greatest in interface HibernateCriteriaBuilder
    
    Specified by:
    
    greatest in interface NodeBuilder
  - least
```
public <X extends Comparable<? super X>> SqmExpression<X> least(Expression<X> argument)
```
    Specified by:
    
    least in interface CriteriaBuilder
    
    Specified by:
    
    least in interface HibernateCriteriaBuilder
    
    Specified by:
    
    least in interface NodeBuilder
  - count
```
public SqmExpression<Long> count(Expression<?> argument)
```
    Specified by:
    
    count in interface CriteriaBuilder
    
    Specified by:
    
    count in interface HibernateCriteriaBuilder
    
    Specified by:
    
    count in interface NodeBuilder
  - countDistinct
```
public SqmExpression<Long> countDistinct(Expression<?> argument)
```
    Specified by:
    
    countDistinct in interface CriteriaBuilder
    
    Specified by:
    
    countDistinct in interface HibernateCriteriaBuilder
    
    Specified by:
    
    countDistinct in interface NodeBuilder
  - sign
```
public JpaExpression<Integer> sign(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the sign of its argument, that is, 1 if its argument is positive, -1 if its argument is negative, or 0 if its argument is exactly zero.
    
    Specified by:
    
    sign in interface CriteriaBuilder
    
    Specified by:
    
    sign in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    sign
  - ceiling
```
public <N extends Number> JpaExpression<N> ceiling(Expression<N> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.
    
    Specified by:
    
    ceiling in interface CriteriaBuilder
    
    Specified by:
    
    ceiling in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    ceiling
  - floor
```
public <N extends Number> JpaExpression<N> floor(Expression<N> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument.
    
    Specified by:
    
    floor in interface CriteriaBuilder
    
    Specified by:
    
    floor in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    floor
  - exp
```
public JpaExpression<Double> exp(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.
    
    Specified by:
    
    exp in interface CriteriaBuilder
    
    Specified by:
    
    exp in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    exponential
  - ln
```
public JpaExpression<Double> ln(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the natural logarithm of its argument.
    
    Specified by:
    
    ln in interface CriteriaBuilder
    
    Specified by:
    
    ln in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    natural logarithm
  - power
```
public JpaExpression<Double> power(Expression<? extends Number> x,
                                   Expression<? extends Number> y)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the first argument raised to the power of its second argument.
    
    Specified by:
    
    power in interface CriteriaBuilder
    
    Specified by:
    
    power in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - base
    
    y - exponent
    
    Returns:
    
    the base raised to the power of the exponent
  - power
```
public JpaExpression<Double> power(Expression<? extends Number> x,
                                   Number y)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the first argument raised to the power of its second argument.
    
    Specified by:
    
    power in interface CriteriaBuilder
    
    Specified by:
    
    power in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - base
    
    y - exponent
    
    Returns:
    
    the base raised to the power of the exponent
  - round
```
public <T extends Number> JpaExpression<T> round(Expression<T> x,
                                                 Integer n)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the first argument rounded to the number of decimal places given by the second argument.
    
    Specified by:
    
    round in interface CriteriaBuilder
    
    Specified by:
    
    round in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - base
    
    n - number of decimal places
    
    Returns:
    
    the rounded value
  - truncate
```
public <T extends Number> JpaExpression<T> truncate(Expression<T> x,
                                                    Integer n)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the first argument truncated to the number of decimal places given by the second argument.
    
    Specified by:
    
    truncate in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - base
    
    n - number of decimal places
    
    Returns:
    
    the truncated value
  - neg
```
public <N extends Number> SqmExpression<N> neg(Expression<N> x)
```
    Specified by:
    
    neg in interface CriteriaBuilder
    
    Specified by:
    
    neg in interface HibernateCriteriaBuilder
    
    Specified by:
    
    neg in interface NodeBuilder
  - abs
```
public <N extends Number> SqmExpression<N> abs(Expression<N> x)
```
    Specified by:
    
    abs in interface CriteriaBuilder
    
    Specified by:
    
    abs in interface HibernateCriteriaBuilder
    
    Specified by:
    
    abs in interface NodeBuilder
  - sum
```
public <N extends Number> SqmExpression<N> sum(Expression<? extends N> x,
                                               Expression<? extends N> y)
```
    Specified by:
    
    sum in interface CriteriaBuilder
    
    Specified by:
    
    sum in interface HibernateCriteriaBuilder
    
    Specified by:
    
    sum in interface NodeBuilder
  - sum
```
public <N extends Number> SqmExpression<N> sum(Expression<? extends N> x,
                                               N y)
```
    Specified by:
    
    sum in interface CriteriaBuilder
    
    Specified by:
    
    sum in interface HibernateCriteriaBuilder
    
    Specified by:
    
    sum in interface NodeBuilder
  - sum
```
public <N extends Number> SqmExpression<N> sum(N x,
                                               Expression<? extends N> y)
```
    Specified by:
    
    sum in interface CriteriaBuilder
    
    Specified by:
    
    sum in interface HibernateCriteriaBuilder
    
    Specified by:
    
    sum in interface NodeBuilder
  - prod
```
public <N extends Number> SqmExpression<N> prod(Expression<? extends N> x,
                                                Expression<? extends N> y)
```
    Specified by:
    
    prod in interface CriteriaBuilder
    
    Specified by:
    
    prod in interface HibernateCriteriaBuilder
    
    Specified by:
    
    prod in interface NodeBuilder
  - prod
```
public <N extends Number> SqmExpression<N> prod(Expression<? extends N> x,
                                                N y)
```
    Specified by:
    
    prod in interface CriteriaBuilder
    
    Specified by:
    
    prod in interface HibernateCriteriaBuilder
    
    Specified by:
    
    prod in interface NodeBuilder
  - prod
```
public <N extends Number> SqmExpression<N> prod(N x,
                                                Expression<? extends N> y)
```
    Specified by:
    
    prod in interface CriteriaBuilder
    
    Specified by:
    
    prod in interface HibernateCriteriaBuilder
    
    Specified by:
    
    prod in interface NodeBuilder
  - diff
```
public <N extends Number> SqmExpression<N> diff(Expression<? extends N> x,
                                                Expression<? extends N> y)
```
    Specified by:
    
    diff in interface CriteriaBuilder
    
    Specified by:
    
    diff in interface HibernateCriteriaBuilder
    
    Specified by:
    
    diff in interface NodeBuilder
  - diff
```
public <N extends Number> SqmExpression<N> diff(Expression<? extends N> x,
                                                N y)
```
    Specified by:
    
    diff in interface CriteriaBuilder
    
    Specified by:
    
    diff in interface HibernateCriteriaBuilder
    
    Specified by:
    
    diff in interface NodeBuilder
  - diff
```
public <N extends Number> SqmExpression<N> diff(N x,
                                                Expression<? extends N> y)
```
    Specified by:
    
    diff in interface CriteriaBuilder
    
    Specified by:
    
    diff in interface HibernateCriteriaBuilder
    
    Specified by:
    
    diff in interface NodeBuilder
  - quot
```
public SqmExpression<Number> quot(Expression<? extends Number> x,
                                  Expression<? extends Number> y)
```
    Specified by:
    
    quot in interface CriteriaBuilder
    
    Specified by:
    
    quot in interface HibernateCriteriaBuilder
    
    Specified by:
    
    quot in interface NodeBuilder
  - quot
```
public SqmExpression<Number> quot(Expression<? extends Number> x,
                                  Number y)
```
    Specified by:
    
    quot in interface CriteriaBuilder
    
    Specified by:
    
    quot in interface HibernateCriteriaBuilder
    
    Specified by:
    
    quot in interface NodeBuilder
  - quot
```
public SqmExpression<Number> quot(Number x,
                                  Expression<? extends Number> y)
```
    Specified by:
    
    quot in interface CriteriaBuilder
    
    Specified by:
    
    quot in interface HibernateCriteriaBuilder
    
    Specified by:
    
    quot in interface NodeBuilder
  - mod
```
public SqmExpression<Integer> mod(Expression<Integer> x,
                                  Expression<Integer> y)
```
    Specified by:
    
    mod in interface CriteriaBuilder
    
    Specified by:
    
    mod in interface HibernateCriteriaBuilder
    
    Specified by:
    
    mod in interface NodeBuilder
  - mod
```
public SqmExpression<Integer> mod(Expression<Integer> x,
                                  Integer y)
```
    Specified by:
    
    mod in interface CriteriaBuilder
    
    Specified by:
    
    mod in interface HibernateCriteriaBuilder
    
    Specified by:
    
    mod in interface NodeBuilder
  - mod
```
public SqmExpression<Integer> mod(Integer x,
                                  Expression<Integer> y)
```
    Specified by:
    
    mod in interface CriteriaBuilder
    
    Specified by:
    
    mod in interface HibernateCriteriaBuilder
    
    Specified by:
    
    mod in interface NodeBuilder
  - sqrt
```
public SqmExpression<Double> sqrt(Expression<? extends Number> x)
```
    Specified by:
    
    sqrt in interface CriteriaBuilder
    
    Specified by:
    
    sqrt in interface HibernateCriteriaBuilder
    
    Specified by:
    
    sqrt in interface NodeBuilder
  - toLong
```
public SqmExpression<Long> toLong(Expression<? extends Number> number)
```
    Specified by:
    
    toLong in interface CriteriaBuilder
    
    Specified by:
    
    toLong in interface HibernateCriteriaBuilder
    
    Specified by:
    
    toLong in interface NodeBuilder
  - toInteger
```
public SqmExpression<Integer> toInteger(Expression<? extends Number> number)
```
    Specified by:
    
    toInteger in interface CriteriaBuilder
    
    Specified by:
    
    toInteger in interface HibernateCriteriaBuilder
    
    Specified by:
    
    toInteger in interface NodeBuilder
  - toFloat
```
public SqmExpression<Float> toFloat(Expression<? extends Number> number)
```
    Specified by:
    
    toFloat in interface CriteriaBuilder
    
    Specified by:
    
    toFloat in interface HibernateCriteriaBuilder
    
    Specified by:
    
    toFloat in interface NodeBuilder
  - toDouble
```
public SqmExpression<Double> toDouble(Expression<? extends Number> number)
```
    Specified by:
    
    toDouble in interface CriteriaBuilder
    
    Specified by:
    
    toDouble in interface HibernateCriteriaBuilder
    
    Specified by:
    
    toDouble in interface NodeBuilder
  - toBigDecimal
```
public SqmExpression<BigDecimal> toBigDecimal(Expression<? extends Number> number)
```
    Specified by:
    
    toBigDecimal in interface CriteriaBuilder
    
    Specified by:
    
    toBigDecimal in interface HibernateCriteriaBuilder
    
    Specified by:
    
    toBigDecimal in interface NodeBuilder
  - toBigInteger
```
public SqmExpression<BigInteger> toBigInteger(Expression<? extends Number> number)
```
    Specified by:
    
    toBigInteger in interface CriteriaBuilder
    
    Specified by:
    
    toBigInteger in interface HibernateCriteriaBuilder
    
    Specified by:
    
    toBigInteger in interface NodeBuilder
  - toString
```
public SqmExpression<String> toString(Expression<Character> character)
```
    Specified by:
    
    toString in interface CriteriaBuilder
    
    Specified by:
    
    toString in interface HibernateCriteriaBuilder
    
    Specified by:
    
    toString in interface NodeBuilder
  - literal
```
public <T> SqmLiteral<T> literal(T value,
                                 SqmExpression<? extends T> typeInferenceSource)
```
    Specified by:
    
    literal in interface HibernateCriteriaBuilder
  - literal
```
public <T> SqmLiteral<T> literal(T value)
```
    Specified by:
    
    literal in interface CriteriaBuilder
    
    Specified by:
    
    literal in interface HibernateCriteriaBuilder
    
    Specified by:
    
    literal in interface NodeBuilder
  - literals
```
public <T> List<? extends SqmExpression<T>> literals(T[] values)
```
    Specified by:
    
    literals in interface HibernateCriteriaBuilder
    
    Specified by:
    
    literals in interface NodeBuilder
  - literals
```
public <T> List<? extends SqmExpression<T>> literals(List<T> values)
```
    Specified by:
    
    literals in interface HibernateCriteriaBuilder
    
    Specified by:
    
    literals in interface NodeBuilder
  - nullLiteral
```
public <T> SqmExpression<T> nullLiteral(Class<T> resultClass)
```
    Specified by:
    
    nullLiteral in interface CriteriaBuilder
    
    Specified by:
    
    nullLiteral in interface HibernateCriteriaBuilder
    
    Specified by:
    
    nullLiteral in interface NodeBuilder
  - parameter
```
public <T> JpaCriteriaParameter<T> parameter(Class<T> paramClass)
```
    Specified by:
    
    parameter in interface CriteriaBuilder
    
    Specified by:
    
    parameter in interface HibernateCriteriaBuilder
    
    Specified by:
    
    parameter in interface NodeBuilder
    
    See Also:
    
    JpaParameterExpression
  - parameter
```
public <T> JpaCriteriaParameter<T> parameter(Class<T> paramClass,
                                             String name)
```
    Specified by:
    
    parameter in interface CriteriaBuilder
    
    Specified by:
    
    parameter in interface HibernateCriteriaBuilder
    
    Specified by:
    
    parameter in interface NodeBuilder
  - concat
```
public SqmExpression<String> concat(Expression<String> x,
                                    Expression<String> y)
```
    Specified by:
    
    concat in interface CriteriaBuilder
    
    Specified by:
    
    concat in interface HibernateCriteriaBuilder
    
    Specified by:
    
    concat in interface NodeBuilder
  - concat
```
public SqmExpression<String> concat(Expression<String> x,
                                    String y)
```
    Specified by:
    
    concat in interface CriteriaBuilder
    
    Specified by:
    
    concat in interface HibernateCriteriaBuilder
    
    Specified by:
    
    concat in interface NodeBuilder
  - concat
```
public SqmExpression<String> concat(String x,
                                    Expression<String> y)
```
    Specified by:
    
    concat in interface CriteriaBuilder
    
    Specified by:
    
    concat in interface HibernateCriteriaBuilder
    
    Specified by:
    
    concat in interface NodeBuilder
  - concat
```
public SqmExpression<String> concat(String x,
                                    String y)
```
    Specified by:
    
    concat in interface HibernateCriteriaBuilder
    
    Specified by:
    
    concat in interface NodeBuilder
  - substring
```
public SqmFunction<String> substring(Expression<String> source,
                                     Expression<Integer> from)
```
    Specified by:
    
    substring in interface CriteriaBuilder
    
    Specified by:
    
    substring in interface HibernateCriteriaBuilder
    
    Specified by:
    
    substring in interface NodeBuilder
  - substring
```
public SqmFunction<String> substring(Expression<String> source,
                                     int from)
```
    Specified by:
    
    substring in interface CriteriaBuilder
    
    Specified by:
    
    substring in interface HibernateCriteriaBuilder
    
    Specified by:
    
    substring in interface NodeBuilder
  - substring
```
public SqmFunction<String> substring(Expression<String> source,
                                     Expression<Integer> from,
                                     Expression<Integer> len)
```
    Specified by:
    
    substring in interface CriteriaBuilder
    
    Specified by:
    
    substring in interface HibernateCriteriaBuilder
    
    Specified by:
    
    substring in interface NodeBuilder
  - substring
```
public SqmFunction<String> substring(Expression<String> source,
                                     int from,
                                     int len)
```
    Specified by:
    
    substring in interface CriteriaBuilder
    
    Specified by:
    
    substring in interface HibernateCriteriaBuilder
    
    Specified by:
    
    substring in interface NodeBuilder
  - trim
```
public SqmFunction<String> trim(Expression<String> source)
```
    Specified by:
    
    trim in interface CriteriaBuilder
    
    Specified by:
    
    trim in interface HibernateCriteriaBuilder
    
    Specified by:
    
    trim in interface NodeBuilder
  - trim
```
public SqmFunction<String> trim(CriteriaBuilder.Trimspec ts,
                                Expression<String> source)
```
    Specified by:
    
    trim in interface CriteriaBuilder
    
    Specified by:
    
    trim in interface HibernateCriteriaBuilder
    
    Specified by:
    
    trim in interface NodeBuilder
  - trim
```
public SqmFunction<String> trim(Expression<Character> trimChar,
                                Expression<String> source)
```
    Specified by:
    
    trim in interface CriteriaBuilder
    
    Specified by:
    
    trim in interface HibernateCriteriaBuilder
    
    Specified by:
    
    trim in interface NodeBuilder
  - trim
```
public SqmFunction<String> trim(CriteriaBuilder.Trimspec ts,
                                Expression<Character> trimChar,
                                Expression<String> source)
```
    Specified by:
    
    trim in interface CriteriaBuilder
    
    Specified by:
    
    trim in interface HibernateCriteriaBuilder
    
    Specified by:
    
    trim in interface NodeBuilder
  - trim
```
public SqmFunction<String> trim(char trimChar,
                                Expression<String> source)
```
    Specified by:
    
    trim in interface CriteriaBuilder
    
    Specified by:
    
    trim in interface HibernateCriteriaBuilder
    
    Specified by:
    
    trim in interface NodeBuilder
  - trim
```
public SqmFunction<String> trim(CriteriaBuilder.Trimspec ts,
                                char trimChar,
                                Expression<String> source)
```
    Specified by:
    
    trim in interface CriteriaBuilder
    
    Specified by:
    
    trim in interface HibernateCriteriaBuilder
    
    Specified by:
    
    trim in interface NodeBuilder
  - lower
```
public SqmFunction<String> lower(Expression<String> x)
```
    Specified by:
    
    lower in interface CriteriaBuilder
    
    Specified by:
    
    lower in interface HibernateCriteriaBuilder
    
    Specified by:
    
    lower in interface NodeBuilder
  - upper
```
public SqmFunction<String> upper(Expression<String> x)
```
    Specified by:
    
    upper in interface CriteriaBuilder
    
    Specified by:
    
    upper in interface HibernateCriteriaBuilder
    
    Specified by:
    
    upper in interface NodeBuilder
  - length
```
public SqmFunction<Integer> length(Expression<String> argument)
```
    Specified by:
    
    length in interface CriteriaBuilder
    
    Specified by:
    
    length in interface HibernateCriteriaBuilder
    
    Specified by:
    
    length in interface NodeBuilder
  - locate
```
public SqmFunction<Integer> locate(Expression<String> source,
                                   Expression<String> pattern)
```
    Specified by:
    
    locate in interface CriteriaBuilder
    
    Specified by:
    
    locate in interface HibernateCriteriaBuilder
    
    Specified by:
    
    locate in interface NodeBuilder
  - locate
```
public SqmFunction<Integer> locate(Expression<String> source,
                                   String pattern)
```
    Specified by:
    
    locate in interface CriteriaBuilder
    
    Specified by:
    
    locate in interface HibernateCriteriaBuilder
    
    Specified by:
    
    locate in interface NodeBuilder
  - locate
```
public SqmFunction<Integer> locate(Expression<String> source,
                                   Expression<String> pattern,
                                   Expression<Integer> startPosition)
```
    Specified by:
    
    locate in interface CriteriaBuilder
    
    Specified by:
    
    locate in interface HibernateCriteriaBuilder
    
    Specified by:
    
    locate in interface NodeBuilder
  - locate
```
public SqmFunction<Integer> locate(Expression<String> source,
                                   String pattern,
                                   int startPosition)
```
    Specified by:
    
    locate in interface CriteriaBuilder
    
    Specified by:
    
    locate in interface HibernateCriteriaBuilder
    
    Specified by:
    
    locate in interface NodeBuilder
  - currentDate
```
public SqmFunction<Date> currentDate()
```
    Specified by:
    
    currentDate in interface CriteriaBuilder
    
    Specified by:
    
    currentDate in interface HibernateCriteriaBuilder
    
    Specified by:
    
    currentDate in interface NodeBuilder
  - currentTimestamp
```
public SqmFunction<Timestamp> currentTimestamp()
```
    Specified by:
    
    currentTimestamp in interface CriteriaBuilder
    
    Specified by:
    
    currentTimestamp in interface HibernateCriteriaBuilder
    
    Specified by:
    
    currentTimestamp in interface NodeBuilder
  - currentTime
```
public SqmFunction<Time> currentTime()
```
    Specified by:
    
    currentTime in interface CriteriaBuilder
    
    Specified by:
    
    currentTime in interface HibernateCriteriaBuilder
    
    Specified by:
    
    currentTime in interface NodeBuilder
  - currentInstant
```
public SqmFunction<Instant> currentInstant()
```
    Specified by:
    
    currentInstant in interface HibernateCriteriaBuilder
    
    Specified by:
    
    currentInstant in interface NodeBuilder
  - localDate
```
public JpaExpression<LocalDate> localDate()
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create expression to return current local date.
    
    Specified by:
    
    localDate in interface CriteriaBuilder
    
    Specified by:
    
    localDate in interface HibernateCriteriaBuilder
    
    Returns:
    
    expression for current date
  - localDateTime
```
public JpaExpression<LocalDateTime> localDateTime()
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create expression to return current local datetime.
    
    Specified by:
    
    localDateTime in interface CriteriaBuilder
    
    Specified by:
    
    localDateTime in interface HibernateCriteriaBuilder
    
    Returns:
    
    expression for current timestamp
  - localTime
```
public JpaExpression<LocalTime> localTime()
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create expression to return current local time.
    
    Specified by:
    
    localTime in interface CriteriaBuilder
    
    Specified by:
    
    localTime in interface HibernateCriteriaBuilder
    
    Returns:
    
    expression for current time
  - function
```
public <T> SqmFunction<T> function(String name,
                                   Class<T> type,
                                   Expression<?>[] args)
```
    Specified by:
    
    function in interface CriteriaBuilder
    
    Specified by:
    
    function in interface HibernateCriteriaBuilder
    
    Specified by:
    
    function in interface NodeBuilder
  - all
```
public <Y> SqmModifiedSubQueryExpression<Y> all(Subquery<Y> subquery)
```
    Specified by:
    
    all in interface CriteriaBuilder
    
    Specified by:
    
    all in interface HibernateCriteriaBuilder
    
    Specified by:
    
    all in interface NodeBuilder
  - some
```
public <Y> SqmModifiedSubQueryExpression<Y> some(Subquery<Y> subquery)
```
    Specified by:
    
    some in interface CriteriaBuilder
    
    Specified by:
    
    some in interface HibernateCriteriaBuilder
    
    Specified by:
    
    some in interface NodeBuilder
  - any
```
public <Y> SqmModifiedSubQueryExpression<Y> any(Subquery<Y> subquery)
```
    Specified by:
    
    any in interface CriteriaBuilder
    
    Specified by:
    
    any in interface HibernateCriteriaBuilder
    
    Specified by:
    
    any in interface NodeBuilder
  - keys
```
public <K,M extends Map<K,?>> SqmExpression<Set<K>> keys(M map)
```
    Specified by:
    
    keys in interface CriteriaBuilder
    
    Specified by:
    
    keys in interface HibernateCriteriaBuilder
    
    Specified by:
    
    keys in interface NodeBuilder
  - indexes
```
public <K,L extends List<?>> SqmExpression<Set<K>> indexes(L list)
```
    Specified by:
    
    indexes in interface HibernateCriteriaBuilder
    
    Specified by:
    
    indexes in interface NodeBuilder
  - value
```
public <T> SqmExpression<T> value(T value,
                                  SqmExpression<? extends T> typeInferenceSource)
```
    Creates an expression for the value with the given "type inference" information
    
    Specified by:
    
    value in interface HibernateCriteriaBuilder
  - value
```
public <T> SqmExpression<T> value(T value)
```
    Specified by:
    
    value in interface HibernateCriteriaBuilder
  - values
```
public <V,C extends Collection<V>> SqmExpression<Collection<V>> values(C collection)
```
    Specified by:
    
    values in interface HibernateCriteriaBuilder
    
    Specified by:
    
    values in interface NodeBuilder
  - values
```
public <V,M extends Map<?,V>> Expression<Collection<V>> values(M map)
```
    Specified by:
    
    values in interface CriteriaBuilder
    
    Specified by:
    
    values in interface HibernateCriteriaBuilder
    
    Specified by:
    
    values in interface NodeBuilder
  - size
```
public <C extends Collection<?>> SqmExpression<Integer> size(Expression<C> collection)
```
    Specified by:
    
    size in interface CriteriaBuilder
    
    Specified by:
    
    size in interface HibernateCriteriaBuilder
    
    Specified by:
    
    size in interface NodeBuilder
  - size
```
public <C extends Collection<?>> SqmExpression<Integer> size(C collection)
```
    Specified by:
    
    size in interface CriteriaBuilder
    
    Specified by:
    
    size in interface HibernateCriteriaBuilder
    
    Specified by:
    
    size in interface NodeBuilder
  - coalesce
```
public <T> SqmCoalesce<T> coalesce()
```
    Specified by:
    
    coalesce in interface CriteriaBuilder
    
    Specified by:
    
    coalesce in interface HibernateCriteriaBuilder
    
    Specified by:
    
    coalesce in interface NodeBuilder
  - coalesce
```
public <Y> JpaCoalesce<Y> coalesce(Expression<? extends Y> x,
                                   Expression<? extends Y> y)
```
    Specified by:
    
    coalesce in interface CriteriaBuilder
    
    Specified by:
    
    coalesce in interface HibernateCriteriaBuilder
    
    Specified by:
    
    coalesce in interface NodeBuilder
  - coalesce
```
public <Y> JpaCoalesce<Y> coalesce(Expression<? extends Y> x,
                                   Y y)
```
    Specified by:
    
    coalesce in interface CriteriaBuilder
    
    Specified by:
    
    coalesce in interface HibernateCriteriaBuilder
    
    Specified by:
    
    coalesce in interface NodeBuilder
  - nullif
```
public <Y> SqmExpression<Y> nullif(Expression<Y> x,
                                   Expression<?> y)
```
    Specified by:
    
    nullif in interface CriteriaBuilder
    
    Specified by:
    
    nullif in interface HibernateCriteriaBuilder
    
    Specified by:
    
    nullif in interface NodeBuilder
  - nullif
```
public <Y> SqmExpression<Y> nullif(Expression<Y> x,
                                   Y y)
```
    Specified by:
    
    nullif in interface CriteriaBuilder
    
    Specified by:
    
    nullif in interface HibernateCriteriaBuilder
    
    Specified by:
    
    nullif in interface NodeBuilder
  - selectCase
```
public <C,R> SqmCaseSimple<C,R> selectCase(Expression<? extends C> expression)
```
    Specified by:
    
    selectCase in interface CriteriaBuilder
    
    Specified by:
    
    selectCase in interface HibernateCriteriaBuilder
    
    Specified by:
    
    selectCase in interface NodeBuilder
  - selectCase
```
public <R> SqmCaseSearched<R> selectCase()
```
    Specified by:
    
    selectCase in interface CriteriaBuilder
    
    Specified by:
    
    selectCase in interface HibernateCriteriaBuilder
    
    Specified by:
    
    selectCase in interface NodeBuilder
  - mapSize
```
public <M extends Map<?,?>> SqmExpression<Integer> mapSize(JpaExpression<M> mapExpression)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that tests the size of a map.
    
    Specified by:
    
    mapSize in interface HibernateCriteriaBuilder
    
    Specified by:
    
    mapSize in interface NodeBuilder
    
    Parameters:
    
    mapExpression - The expression resolving to a Map for which we want to know the size
    
    Returns:
    
    size expression
  - mapSize
```
public <M extends Map<?,?>> SqmExpression<Integer> mapSize(M map)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that tests the size of a map.
    
    Specified by:
    
    mapSize in interface HibernateCriteriaBuilder
    
    Specified by:
    
    mapSize in interface NodeBuilder
    
    Parameters:
    
    map - The Map for which we want to know the size
    
    Returns:
    
    size expression
  - and
```
public SqmPredicate and(Expression<Boolean> x,
                        Expression<Boolean> y)
```
    Specified by:
    
    and in interface CriteriaBuilder
    
    Specified by:
    
    and in interface HibernateCriteriaBuilder
    
    Specified by:
    
    and in interface NodeBuilder
  - and
```
public SqmPredicate and(Predicate... restrictions)
```
    Specified by:
    
    and in interface CriteriaBuilder
    
    Specified by:
    
    and in interface HibernateCriteriaBuilder
    
    Specified by:
    
    and in interface NodeBuilder
  - or
```
public SqmPredicate or(Expression<Boolean> x,
                       Expression<Boolean> y)
```
    Specified by:
    
    or in interface CriteriaBuilder
    
    Specified by:
    
    or in interface HibernateCriteriaBuilder
    
    Specified by:
    
    or in interface NodeBuilder
  - or
```
public SqmPredicate or(Predicate... restrictions)
```
    Specified by:
    
    or in interface CriteriaBuilder
    
    Specified by:
    
    or in interface HibernateCriteriaBuilder
    
    Specified by:
    
    or in interface NodeBuilder
  - not
```
public SqmPredicate not(Expression<Boolean> restriction)
```
    Specified by:
    
    not in interface CriteriaBuilder
    
    Specified by:
    
    not in interface HibernateCriteriaBuilder
    
    Specified by:
    
    not in interface NodeBuilder
  - conjunction
```
public SqmPredicate conjunction()
```
    Specified by:
    
    conjunction in interface CriteriaBuilder
    
    Specified by:
    
    conjunction in interface HibernateCriteriaBuilder
    
    Specified by:
    
    conjunction in interface NodeBuilder
  - disjunction
```
public SqmPredicate disjunction()
```
    Specified by:
    
    disjunction in interface CriteriaBuilder
    
    Specified by:
    
    disjunction in interface HibernateCriteriaBuilder
    
    Specified by:
    
    disjunction in interface NodeBuilder
  - isTrue
```
public SqmPredicate isTrue(Expression<Boolean> x)
```
    Specified by:
    
    isTrue in interface CriteriaBuilder
    
    Specified by:
    
    isTrue in interface HibernateCriteriaBuilder
    
    Specified by:
    
    isTrue in interface NodeBuilder
  - isFalse
```
public SqmPredicate isFalse(Expression<Boolean> x)
```
    Specified by:
    
    isFalse in interface CriteriaBuilder
    
    Specified by:
    
    isFalse in interface HibernateCriteriaBuilder
    
    Specified by:
    
    isFalse in interface NodeBuilder
  - isNull
```
public SqmPredicate isNull(Expression<?> x)
```
    Specified by:
    
    isNull in interface CriteriaBuilder
    
    Specified by:
    
    isNull in interface HibernateCriteriaBuilder
    
    Specified by:
    
    isNull in interface NodeBuilder
  - isNotNull
```
public SqmPredicate isNotNull(Expression<?> x)
```
    Specified by:
    
    isNotNull in interface CriteriaBuilder
    
    Specified by:
    
    isNotNull in interface HibernateCriteriaBuilder
    
    Specified by:
    
    isNotNull in interface NodeBuilder
  - between
```
public <Y extends Comparable<? super Y>> SqmPredicate between(Expression<? extends Y> value,
                                                              Expression<? extends Y> lower,
                                                              Expression<? extends Y> upper)
```
    Specified by:
    
    between in interface CriteriaBuilder
    
    Specified by:
    
    between in interface HibernateCriteriaBuilder
    
    Specified by:
    
    between in interface NodeBuilder
  - between
```
public <Y extends Comparable<? super Y>> SqmPredicate between(Expression<? extends Y> value,
                                                              Y lower,
                                                              Y upper)
```
    Specified by:
    
    between in interface CriteriaBuilder
    
    Specified by:
    
    between in interface HibernateCriteriaBuilder
    
    Specified by:
    
    between in interface NodeBuilder
  - assertComparable
```
public void assertComparable(Expression<?> x,
                             Expression<?> y)
```
  - equal
```
public SqmPredicate equal(Expression<?> x,
                          Expression<?> y)
```
    Specified by:
    
    equal in interface CriteriaBuilder
    
    Specified by:
    
    equal in interface HibernateCriteriaBuilder
    
    Specified by:
    
    equal in interface NodeBuilder
  - equal
```
public SqmPredicate equal(Expression<?> x,
                          Object y)
```
    Specified by:
    
    equal in interface CriteriaBuilder
    
    Specified by:
    
    equal in interface HibernateCriteriaBuilder
    
    Specified by:
    
    equal in interface NodeBuilder
  - notEqual
```
public SqmPredicate notEqual(Expression<?> x,
                             Expression<?> y)
```
    Specified by:
    
    notEqual in interface CriteriaBuilder
    
    Specified by:
    
    notEqual in interface HibernateCriteriaBuilder
    
    Specified by:
    
    notEqual in interface NodeBuilder
  - notEqual
```
public SqmPredicate notEqual(Expression<?> x,
                             Object y)
```
    Specified by:
    
    notEqual in interface CriteriaBuilder
    
    Specified by:
    
    notEqual in interface HibernateCriteriaBuilder
    
    Specified by:
    
    notEqual in interface NodeBuilder
  - distinctFrom
```
public SqmPredicate distinctFrom(Expression<?> x,
                                 Expression<?> y)
```
    Specified by:
    
    distinctFrom in interface HibernateCriteriaBuilder
    
    Specified by:
    
    distinctFrom in interface NodeBuilder
  - distinctFrom
```
public SqmPredicate distinctFrom(Expression<?> x,
                                 Object y)
```
    Specified by:
    
    distinctFrom in interface HibernateCriteriaBuilder
    
    Specified by:
    
    distinctFrom in interface NodeBuilder
  - notDistinctFrom
```
public SqmPredicate notDistinctFrom(Expression<?> x,
                                    Expression<?> y)
```
    Specified by:
    
    notDistinctFrom in interface HibernateCriteriaBuilder
    
    Specified by:
    
    notDistinctFrom in interface NodeBuilder
  - notDistinctFrom
```
public SqmPredicate notDistinctFrom(Expression<?> x,
                                    Object y)
```
    Specified by:
    
    notDistinctFrom in interface HibernateCriteriaBuilder
    
    Specified by:
    
    notDistinctFrom in interface NodeBuilder
  - greaterThan
```
public <Y extends Comparable<? super Y>> SqmPredicate greaterThan(Expression<? extends Y> x,
                                                                  Expression<? extends Y> y)
```
    Specified by:
    
    greaterThan in interface CriteriaBuilder
    
    Specified by:
    
    greaterThan in interface HibernateCriteriaBuilder
    
    Specified by:
    
    greaterThan in interface NodeBuilder
  - greaterThan
```
public <Y extends Comparable<? super Y>> SqmPredicate greaterThan(Expression<? extends Y> x,
                                                                  Y y)
```
    Specified by:
    
    greaterThan in interface CriteriaBuilder
    
    Specified by:
    
    greaterThan in interface HibernateCriteriaBuilder
    
    Specified by:
    
    greaterThan in interface NodeBuilder
  - greaterThanOrEqualTo
```
public <Y extends Comparable<? super Y>> SqmPredicate greaterThanOrEqualTo(Expression<? extends Y> x,
                                                                           Expression<? extends Y> y)
```
    Specified by:
    
    greaterThanOrEqualTo in interface CriteriaBuilder
    
    Specified by:
    
    greaterThanOrEqualTo in interface HibernateCriteriaBuilder
    
    Specified by:
    
    greaterThanOrEqualTo in interface NodeBuilder
  - greaterThanOrEqualTo
```
public <Y extends Comparable<? super Y>> SqmPredicate greaterThanOrEqualTo(Expression<? extends Y> x,
                                                                           Y y)
```
    Specified by:
    
    greaterThanOrEqualTo in interface CriteriaBuilder
    
    Specified by:
    
    greaterThanOrEqualTo in interface HibernateCriteriaBuilder
    
    Specified by:
    
    greaterThanOrEqualTo in interface NodeBuilder
  - lessThan
```
public <Y extends Comparable<? super Y>> SqmPredicate lessThan(Expression<? extends Y> x,
                                                               Expression<? extends Y> y)
```
    Specified by:
    
    lessThan in interface CriteriaBuilder
    
    Specified by:
    
    lessThan in interface HibernateCriteriaBuilder
    
    Specified by:
    
    lessThan in interface NodeBuilder
  - lessThan
```
public <Y extends Comparable<? super Y>> SqmPredicate lessThan(Expression<? extends Y> x,
                                                               Y y)
```
    Specified by:
    
    lessThan in interface CriteriaBuilder
    
    Specified by:
    
    lessThan in interface HibernateCriteriaBuilder
    
    Specified by:
    
    lessThan in interface NodeBuilder
  - lessThanOrEqualTo
```
public <Y extends Comparable<? super Y>> SqmPredicate lessThanOrEqualTo(Expression<? extends Y> x,
                                                                        Expression<? extends Y> y)
```
    Specified by:
    
    lessThanOrEqualTo in interface CriteriaBuilder
    
    Specified by:
    
    lessThanOrEqualTo in interface HibernateCriteriaBuilder
    
    Specified by:
    
    lessThanOrEqualTo in interface NodeBuilder
  - lessThanOrEqualTo
```
public <Y extends Comparable<? super Y>> SqmPredicate lessThanOrEqualTo(Expression<? extends Y> x,
                                                                        Y y)
```
    Specified by:
    
    lessThanOrEqualTo in interface CriteriaBuilder
    
    Specified by:
    
    lessThanOrEqualTo in interface HibernateCriteriaBuilder
    
    Specified by:
    
    lessThanOrEqualTo in interface NodeBuilder
  - gt
```
public SqmPredicate gt(Expression<? extends Number> x,
                       Expression<? extends Number> y)
```
    Specified by:
    
    gt in interface CriteriaBuilder
    
    Specified by:
    
    gt in interface HibernateCriteriaBuilder
    
    Specified by:
    
    gt in interface NodeBuilder
  - gt
```
public SqmPredicate gt(Expression<? extends Number> x,
                       Number y)
```
    Specified by:
    
    gt in interface CriteriaBuilder
    
    Specified by:
    
    gt in interface HibernateCriteriaBuilder
    
    Specified by:
    
    gt in interface NodeBuilder
  - ge
```
public SqmPredicate ge(Expression<? extends Number> x,
                       Expression<? extends Number> y)
```
    Specified by:
    
    ge in interface CriteriaBuilder
    
    Specified by:
    
    ge in interface HibernateCriteriaBuilder
    
    Specified by:
    
    ge in interface NodeBuilder
  - ge
```
public SqmPredicate ge(Expression<? extends Number> x,
                       Number y)
```
    Specified by:
    
    ge in interface CriteriaBuilder
    
    Specified by:
    
    ge in interface HibernateCriteriaBuilder
    
    Specified by:
    
    ge in interface NodeBuilder
  - lt
```
public SqmPredicate lt(Expression<? extends Number> x,
                       Expression<? extends Number> y)
```
    Specified by:
    
    lt in interface CriteriaBuilder
    
    Specified by:
    
    lt in interface HibernateCriteriaBuilder
    
    Specified by:
    
    lt in interface NodeBuilder
  - lt
```
public SqmPredicate lt(Expression<? extends Number> x,
                       Number y)
```
    Specified by:
    
    lt in interface CriteriaBuilder
    
    Specified by:
    
    lt in interface HibernateCriteriaBuilder
    
    Specified by:
    
    lt in interface NodeBuilder
  - le
```
public SqmPredicate le(Expression<? extends Number> x,
                       Expression<? extends Number> y)
```
    Specified by:
    
    le in interface CriteriaBuilder
    
    Specified by:
    
    le in interface HibernateCriteriaBuilder
    
    Specified by:
    
    le in interface NodeBuilder
  - le
```
public SqmPredicate le(Expression<? extends Number> x,
                       Number y)
```
    Specified by:
    
    le in interface CriteriaBuilder
    
    Specified by:
    
    le in interface HibernateCriteriaBuilder
    
    Specified by:
    
    le in interface NodeBuilder
  - isEmpty
```
public <C extends Collection<?>> SqmPredicate isEmpty(Expression<C> collection)
```
    Specified by:
    
    isEmpty in interface CriteriaBuilder
    
    Specified by:
    
    isEmpty in interface HibernateCriteriaBuilder
    
    Specified by:
    
    isEmpty in interface NodeBuilder
  - isNotEmpty
```
public <C extends Collection<?>> SqmPredicate isNotEmpty(Expression<C> collection)
```
    Specified by:
    
    isNotEmpty in interface CriteriaBuilder
    
    Specified by:
    
    isNotEmpty in interface HibernateCriteriaBuilder
    
    Specified by:
    
    isNotEmpty in interface NodeBuilder
  - isMember
```
public <E,C extends Collection<E>> SqmPredicate isMember(Expression<E> elem,
                                                               Expression<C> collection)
```
    Specified by:
    
    isMember in interface CriteriaBuilder
    
    Specified by:
    
    isMember in interface HibernateCriteriaBuilder
    
    Specified by:
    
    isMember in interface NodeBuilder
  - isMember
```
public <E,C extends Collection<E>> SqmPredicate isMember(E elem,
                                                               Expression<C> collection)
```
    Specified by:
    
    isMember in interface CriteriaBuilder
    
    Specified by:
    
    isMember in interface HibernateCriteriaBuilder
    
    Specified by:
    
    isMember in interface NodeBuilder
  - isNotMember
```
public <E,C extends Collection<E>> SqmPredicate isNotMember(Expression<E> elem,
                                                                  Expression<C> collection)
```
    Specified by:
    
    isNotMember in interface CriteriaBuilder
    
    Specified by:
    
    isNotMember in interface HibernateCriteriaBuilder
    
    Specified by:
    
    isNotMember in interface NodeBuilder
  - isNotMember
```
public <E,C extends Collection<E>> SqmPredicate isNotMember(E elem,
                                                                  Expression<C> collection)
```
    Specified by:
    
    isNotMember in interface CriteriaBuilder
    
    Specified by:
    
    isNotMember in interface HibernateCriteriaBuilder
    
    Specified by:
    
    isNotMember in interface NodeBuilder
  - like
```
public SqmPredicate like(Expression<String> searchString,
                         Expression<String> pattern)
```
    Specified by:
    
    like in interface CriteriaBuilder
    
    Specified by:
    
    like in interface HibernateCriteriaBuilder
    
    Specified by:
    
    like in interface NodeBuilder
  - like
```
public SqmPredicate like(Expression<String> searchString,
                         String pattern)
```
    Specified by:
    
    like in interface CriteriaBuilder
    
    Specified by:
    
    like in interface HibernateCriteriaBuilder
    
    Specified by:
    
    like in interface NodeBuilder
  - like
```
public SqmPredicate like(Expression<String> searchString,
                         Expression<String> pattern,
                         Expression<Character> escapeChar)
```
    Specified by:
    
    like in interface CriteriaBuilder
    
    Specified by:
    
    like in interface HibernateCriteriaBuilder
    
    Specified by:
    
    like in interface NodeBuilder
  - like
```
public SqmPredicate like(Expression<String> searchString,
                         Expression<String> pattern,
                         char escapeChar)
```
    Specified by:
    
    like in interface CriteriaBuilder
    
    Specified by:
    
    like in interface HibernateCriteriaBuilder
    
    Specified by:
    
    like in interface NodeBuilder
  - like
```
public SqmPredicate like(Expression<String> searchString,
                         String pattern,
                         Expression<Character> escapeChar)
```
    Specified by:
    
    like in interface CriteriaBuilder
    
    Specified by:
    
    like in interface HibernateCriteriaBuilder
    
    Specified by:
    
    like in interface NodeBuilder
  - like
```
public SqmPredicate like(Expression<String> searchString,
                         String pattern,
                         char escapeChar)
```
    Specified by:
    
    like in interface CriteriaBuilder
    
    Specified by:
    
    like in interface HibernateCriteriaBuilder
    
    Specified by:
    
    like in interface NodeBuilder
  - ilike
```
public SqmPredicate ilike(Expression<String> searchString,
                          Expression<String> pattern)
```
    Specified by:
    
    ilike in interface HibernateCriteriaBuilder
  - ilike
```
public SqmPredicate ilike(Expression<String> searchString,
                          String pattern)
```
    Specified by:
    
    ilike in interface HibernateCriteriaBuilder
  - ilike
```
public SqmPredicate ilike(Expression<String> searchString,
                          Expression<String> pattern,
                          Expression<Character> escapeChar)
```
    Specified by:
    
    ilike in interface HibernateCriteriaBuilder
  - ilike
```
public SqmPredicate ilike(Expression<String> searchString,
                          Expression<String> pattern,
                          char escapeChar)
```
    Specified by:
    
    ilike in interface HibernateCriteriaBuilder
  - ilike
```
public SqmPredicate ilike(Expression<String> searchString,
                          String pattern,
                          Expression<Character> escapeChar)
```
    Specified by:
    
    ilike in interface HibernateCriteriaBuilder
  - ilike
```
public SqmPredicate ilike(Expression<String> searchString,
                          String pattern,
                          char escapeChar)
```
    Specified by:
    
    ilike in interface HibernateCriteriaBuilder
  - notLike
```
public SqmPredicate notLike(Expression<String> x,
                            Expression<String> pattern)
```
    Specified by:
    
    notLike in interface CriteriaBuilder
    
    Specified by:
    
    notLike in interface HibernateCriteriaBuilder
    
    Specified by:
    
    notLike in interface NodeBuilder
  - notLike
```
public SqmPredicate notLike(Expression<String> x,
                            String pattern)
```
    Specified by:
    
    notLike in interface CriteriaBuilder
    
    Specified by:
    
    notLike in interface HibernateCriteriaBuilder
    
    Specified by:
    
    notLike in interface NodeBuilder
  - notLike
```
public SqmPredicate notLike(Expression<String> x,
                            Expression<String> pattern,
                            Expression<Character> escapeChar)
```
    Specified by:
    
    notLike in interface CriteriaBuilder
    
    Specified by:
    
    notLike in interface HibernateCriteriaBuilder
    
    Specified by:
    
    notLike in interface NodeBuilder
  - notLike
```
public SqmPredicate notLike(Expression<String> x,
                            Expression<String> pattern,
                            char escapeChar)
```
    Specified by:
    
    notLike in interface CriteriaBuilder
    
    Specified by:
    
    notLike in interface HibernateCriteriaBuilder
    
    Specified by:
    
    notLike in interface NodeBuilder
  - notLike
```
public SqmPredicate notLike(Expression<String> x,
                            String pattern,
                            Expression<Character> escapeChar)
```
    Specified by:
    
    notLike in interface CriteriaBuilder
    
    Specified by:
    
    notLike in interface HibernateCriteriaBuilder
    
    Specified by:
    
    notLike in interface NodeBuilder
  - notLike
```
public SqmPredicate notLike(Expression<String> x,
                            String pattern,
                            char escapeChar)
```
    Specified by:
    
    notLike in interface CriteriaBuilder
    
    Specified by:
    
    notLike in interface HibernateCriteriaBuilder
    
    Specified by:
    
    notLike in interface NodeBuilder
  - notIlike
```
public SqmPredicate notIlike(Expression<String> x,
                             Expression<String> pattern)
```
    Specified by:
    
    notIlike in interface HibernateCriteriaBuilder
  - notIlike
```
public SqmPredicate notIlike(Expression<String> x,
                             String pattern)
```
    Specified by:
    
    notIlike in interface HibernateCriteriaBuilder
  - notIlike
```
public SqmPredicate notIlike(Expression<String> x,
                             Expression<String> pattern,
                             Expression<Character> escapeChar)
```
    Specified by:
    
    notIlike in interface HibernateCriteriaBuilder
  - notIlike
```
public SqmPredicate notIlike(Expression<String> x,
                             Expression<String> pattern,
                             char escapeChar)
```
    Specified by:
    
    notIlike in interface HibernateCriteriaBuilder
  - notIlike
```
public SqmPredicate notIlike(Expression<String> x,
                             String pattern,
                             Expression<Character> escapeChar)
```
    Specified by:
    
    notIlike in interface HibernateCriteriaBuilder
  - notIlike
```
public SqmPredicate notIlike(Expression<String> x,
                             String pattern,
                             char escapeChar)
```
    Specified by:
    
    notIlike in interface HibernateCriteriaBuilder
  - in
```
public <T> SqmInPredicate<T> in(Expression<? extends T> expression)
```
    Specified by:
    
    in in interface CriteriaBuilder
    
    Specified by:
    
    in in interface HibernateCriteriaBuilder
    
    Specified by:
    
    in in interface NodeBuilder
  - in
```
public <T> SqmInPredicate<T> in(Expression<? extends T> expression,
                                Expression<? extends T>... values)
```
    Specified by:
    
    in in interface HibernateCriteriaBuilder
    
    Specified by:
    
    in in interface NodeBuilder
  - in
```
public <T> SqmInPredicate<T> in(Expression<? extends T> expression,
                                T... values)
```
    Specified by:
    
    in in interface HibernateCriteriaBuilder
    
    Specified by:
    
    in in interface NodeBuilder
  - in
```
public <T> SqmInPredicate<T> in(Expression<? extends T> expression,
                                Collection<T> values)
```
    Specified by:
    
    in in interface HibernateCriteriaBuilder
    
    Specified by:
    
    in in interface NodeBuilder
  - in
```
public <T> SqmInPredicate<T> in(Expression<? extends T> expression,
                                SqmSubQuery<T> subQuery)
```
    Specified by:
    
    in in interface NodeBuilder
  - exists
```
public SqmPredicate exists(Subquery<?> subQuery)
```
    Specified by:
    
    exists in interface CriteriaBuilder
    
    Specified by:
    
    exists in interface HibernateCriteriaBuilder
    
    Specified by:
    
    exists in interface NodeBuilder
  - isMapEmpty
```
public <M extends Map<?,?>> SqmPredicate isMapEmpty(JpaExpression<M> mapExpression)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a predicate that tests whether a Map is empty.
    
    Specified by:
    
    isMapEmpty in interface HibernateCriteriaBuilder
    
    Specified by:
    
    isMapEmpty in interface NodeBuilder
    
    Parameters:
    
    mapExpression - The expression resolving to a Map which we want to check for emptiness
    
    Returns:
    
    is-empty predicate
  - isMapNotEmpty
```
public <M extends Map<?,?>> SqmPredicate isMapNotEmpty(JpaExpression<M> mapExpression)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a predicate that tests whether a Map is not empty.
    
    Specified by:
    
    isMapNotEmpty in interface HibernateCriteriaBuilder
    
    Specified by:
    
    isMapNotEmpty in interface NodeBuilder
    
    Parameters:
    
    mapExpression - The expression resolving to a Map which we want to check for non-emptiness
    
    Returns:
    
    is-not-empty predicate
  - sql
```
public <T> SqmFunction<T> sql(String pattern,
                              Class<T> type,
                              Expression<?>... arguments)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Embed native pattern that will be unquoted and embedded in the generated SQL. Occurrences of ? in the pattern are replaced with the remaining arguments of the function.
    
    Specified by:
    
    sql in interface HibernateCriteriaBuilder
    
    Type Parameters:
    
    T - type of this expression
    
    Parameters:
    
    pattern - native SQL pattern
    
    type - type of this expression
    
    arguments - optional arguments to the SQL pattern
    
    Returns:
    
    native SQL expression
  - format
```
public SqmFunction<String> format(Expression<? extends TemporalAccessor> datetime,
                                  String pattern)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Format a date, time, or datetime according to a pattern. The pattern must be written in a subset of the pattern language defined by Java’s DateTimeFormatter.
    See Dialect.appendDatetimeFormat(org.hibernate.sql.ast.spi.SqlAppender, java.lang.String) for a full list of pattern elements.
    
    Specified by:
    
    format in interface HibernateCriteriaBuilder
    
    Parameters:
    
    datetime - the datetime expression to format
    
    pattern - the pattern to use for formatting
    
    Returns:
    
    format expression
  - year
```
public SqmFunction<Integer> year(Expression<? extends TemporalAccessor> datetime)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Extracts the TemporalUnit.YEAR of a date, time, or datetime expression.
    
    Specified by:
    
    year in interface HibernateCriteriaBuilder
    
    Parameters:
    
    datetime - the date, time, or datetime to extract the value from
    
    Returns:
    
    the extracted value
  - month
```
public SqmFunction<Integer> month(Expression<? extends TemporalAccessor> datetime)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Extracts the TemporalUnit.MONTH of a date, time, or datetime expression.
    
    Specified by:
    
    month in interface HibernateCriteriaBuilder
    
    Parameters:
    
    datetime - the date, time, or datetime to extract the value from
    
    Returns:
    
    the extracted value
  - day
```
public SqmFunction<Integer> day(Expression<? extends TemporalAccessor> datetime)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Extracts the TemporalUnit.DAY of a date, time, or datetime expression.
    
    Specified by:
    
    day in interface HibernateCriteriaBuilder
    
    Parameters:
    
    datetime - the date, time, or datetime to extract the value from
    
    Returns:
    
    the extracted value
  - hour
```
public SqmFunction<Integer> hour(Expression<? extends TemporalAccessor> datetime)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Extracts the TemporalUnit.HOUR of a date, time, or datetime expression.
    
    Specified by:
    
    hour in interface HibernateCriteriaBuilder
    
    Parameters:
    
    datetime - the date, time, or datetime to extract the value from
    
    Returns:
    
    the extracted value
  - minute
```
public SqmFunction<Integer> minute(Expression<? extends TemporalAccessor> datetime)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Extracts the TemporalUnit.MINUTE of a date, time, or datetime expression.
    
    Specified by:
    
    minute in interface HibernateCriteriaBuilder
    
    Parameters:
    
    datetime - the date, time, or datetime to extract the value from
    
    Returns:
    
    the extracted value
  - second
```
public SqmFunction<Float> second(Expression<? extends TemporalAccessor> datetime)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Extracts the TemporalUnit.SECOND of a date, time, or datetime expression.
    
    Specified by:
    
    second in interface HibernateCriteriaBuilder
    
    Parameters:
    
    datetime - the date, time, or datetime to extract the value from
    
    Returns:
    
    the extracted value
  - truncate
```
public <T extends TemporalAccessor> SqmFunction<T> truncate(Expression<T> datetime,
                                                            TemporalUnit temporalUnit)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Truncates a date, time or datetime expression to the given TemporalUnit. Supported units are: YEAR, MONTH, DAY, HOUR, MINUTE, SECOND.
    Truncating translates to obtaining a value of the same type in which all temporal units smaller than field have been pruned. For hours, minutes and second this means setting them to 00. For months and days, this means setting them to 01.
    
    Specified by:
    
    truncate in interface HibernateCriteriaBuilder
    
    Parameters:
    
    datetime - the date, time or datetime expression to be truncated
    
    temporalUnit - the temporal unit for truncation
    
    Returns:
    
    the truncated value
  - overlay
```
public SqmFunction<String> overlay(Expression<String> string,
                                   String replacement,
                                   int start)
```
    Specified by:
    
    overlay in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
  - overlay
```
public SqmFunction<String> overlay(Expression<String> string,
                                   Expression<String> replacement,
                                   int start)
```
    Specified by:
    
    overlay in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
  - overlay
```
public SqmFunction<String> overlay(Expression<String> string,
                                   String replacement,
                                   Expression<Integer> start)
```
    Specified by:
    
    overlay in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
  - overlay
```
public SqmFunction<String> overlay(Expression<String> string,
                                   Expression<String> replacement,
                                   Expression<Integer> start)
```
    Specified by:
    
    overlay in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
  - overlay
```
public SqmFunction<String> overlay(Expression<String> string,
                                   String replacement,
                                   int start,
                                   int length)
```
    Specified by:
    
    overlay in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
  - overlay
```
public SqmFunction<String> overlay(Expression<String> string,
                                   Expression<String> replacement,
                                   int start,
                                   int length)
```
    Specified by:
    
    overlay in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
  - overlay
```
public SqmFunction<String> overlay(Expression<String> string,
                                   String replacement,
                                   Expression<Integer> start,
                                   int length)
```
    Specified by:
    
    overlay in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
  - overlay
```
public SqmFunction<String> overlay(Expression<String> string,
                                   Expression<String> replacement,
                                   Expression<Integer> start,
                                   int length)
```
    Specified by:
    
    overlay in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
  - overlay
```
public SqmFunction<String> overlay(Expression<String> string,
                                   String replacement,
                                   int start,
                                   Expression<Integer> length)
```
    Specified by:
    
    overlay in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
  - overlay
```
public SqmFunction<String> overlay(Expression<String> string,
                                   Expression<String> replacement,
                                   int start,
                                   Expression<Integer> length)
```
    Specified by:
    
    overlay in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
  - overlay
```
public SqmFunction<String> overlay(Expression<String> string,
                                   String replacement,
                                   Expression<Integer> start,
                                   Expression<Integer> length)
```
    Specified by:
    
    overlay in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
  - overlay
```
public SqmFunction<String> overlay(Expression<String> string,
                                   Expression<String> replacement,
                                   Expression<Integer> start,
                                   Expression<Integer> length)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Overlay the string expression with the replacement expression, starting from index start and substituting a number of characters corresponding to the length of the replacement expression or the length parameter if specified.
    
    Specified by:
    
    overlay in interface HibernateCriteriaBuilder
    
    Parameters:
    
    string - string expression to be manipulated
    
    replacement - string expression to replace in original
    
    start - start position
    
    length - optional, number of characters to substitute
    
    Returns:
    
    overlay expression
  - pad
```
public SqmFunction<String> pad(Expression<String> x,
                               int length)
```
    Specified by:
    
    pad in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
  - pad
```
public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts,
                               Expression<String> x,
                               int length)
```
    Specified by:
    
    pad in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
  - pad
```
public SqmFunction<String> pad(Expression<String> x,
                               Expression<Integer> length)
```
    Specified by:
    
    pad in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
  - pad
```
public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts,
                               Expression<String> x,
                               Expression<Integer> length)
```
    Specified by:
    
    pad in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
  - pad
```
public SqmFunction<String> pad(Expression<String> x,
                               int length,
                               char padChar)
```
    Specified by:
    
    pad in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
  - pad
```
public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts,
                               Expression<String> x,
                               int length,
                               char padChar)
```
    Specified by:
    
    pad in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
  - pad
```
public SqmFunction<String> pad(Expression<String> x,
                               int length,
                               Expression<Character> padChar)
```
    Specified by:
    
    pad in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
  - pad
```
public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts,
                               Expression<String> x,
                               int length,
                               Expression<Character> padChar)
```
    Specified by:
    
    pad in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
  - pad
```
public SqmFunction<String> pad(Expression<String> x,
                               Expression<Integer> length,
                               char padChar)
```
    Specified by:
    
    pad in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
  - pad
```
public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts,
                               Expression<String> x,
                               Expression<Integer> length,
                               char padChar)
```
    Specified by:
    
    pad in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
  - pad
```
public SqmFunction<String> pad(Expression<String> x,
                               Expression<Integer> length,
                               Expression<Character> padChar)
```
    Specified by:
    
    pad in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
  - pad
```
public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts,
                               Expression<String> x,
                               Expression<Integer> length,
                               Expression<Character> padChar)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Pad the specified string expression with whitespace or with the padChar character if specified. Optionally pass a CriteriaBuilder.Trimspec to pad the string expression with LEADING or TRAILING (default) characters.
    
    Specified by:
    
    pad in interface HibernateCriteriaBuilder
    
    Parameters:
    
    ts - optional CriteriaBuilder.Trimspec
    
    x - string expression to pad
    
    length - length of the result string after padding
    
    padChar - optional pad character
    
    Returns:
    
    pad expression
  - left
```
public SqmFunction<String> left(Expression<String> x,
                                int length)
```
    Specified by:
    
    left in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.left(Expression, Expression)
  - left
```
public SqmFunction<String> left(Expression<String> x,
                                Expression<Integer> length)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Extract the length leftmost characters of a string.
    
    Specified by:
    
    left in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - original string
    
    length - number of characters
    
    Returns:
    
    left expression
  - right
```
public SqmFunction<String> right(Expression<String> x,
                                 int length)
```
    Specified by:
    
    right in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.right(Expression, Expression)
  - right
```
public SqmFunction<String> right(Expression<String> x,
                                 Expression<Integer> length)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Extract the length rightmost characters of a string.
    
    Specified by:
    
    right in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - original string
    
    length - number of characters
    
    Returns:
    
    left expression
  - replace
```
public SqmFunction<String> replace(Expression<String> x,
                                   String pattern,
                                   String replacement)
```
    Specified by:
    
    replace in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.replace(Expression, Expression, Expression)
  - replace
```
public SqmFunction<String> replace(Expression<String> x,
                                   String pattern,
                                   Expression<String> replacement)
```
    Specified by:
    
    replace in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.replace(Expression, Expression, Expression)
  - replace
```
public SqmFunction<String> replace(Expression<String> x,
                                   Expression<String> pattern,
                                   String replacement)
```
    Specified by:
    
    replace in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.replace(Expression, Expression, Expression)
  - replace
```
public SqmFunction<String> replace(Expression<String> x,
                                   Expression<String> pattern,
                                   Expression<String> replacement)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Replace all occurrences of pattern within the original string with replacement.
    
    Specified by:
    
    replace in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - original string
    
    pattern - the string to be replaced
    
    replacement - the new replacement string
    
    Returns:
    
    replace expression
  - collate
```
public SqmFunction<String> collate(Expression<String> x,
                                   String collation)
```
    Specified by:
    
    collate in interface HibernateCriteriaBuilder
  - log10
```
public SqmFunction<Double> log10(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the base-10 logarithm of its argument.
    
    Specified by:
    
    log10 in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    base-10 logarithm
  - log
```
public SqmFunction<Double> log(Number b,
                               Expression<? extends Number> x)
```
    Specified by:
    
    log in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.log(Expression, Expression)
  - log
```
public SqmFunction<Double> log(Expression<? extends Number> b,
                               Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the logarithm of x to the base b.
    
    Specified by:
    
    log in interface HibernateCriteriaBuilder
    
    Parameters:
    
    b - base
    
    x - expression
    
    Returns:
    
    arbitrary-base logarithm
  - pi
```
public SqmFunction<Double> pi()
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Literal expression corresponding to the value of pi.
    
    Specified by:
    
    pi in interface HibernateCriteriaBuilder
    
    Returns:
    
    pi expression
  - sin
```
public SqmFunction<Double> sin(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the sine of its argument.
    
    Specified by:
    
    sin in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    sine
  - cos
```
public SqmFunction<Double> cos(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the cosine of its argument.
    
    Specified by:
    
    cos in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    cosine
  - tan
```
public SqmFunction<Double> tan(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the tangent of its argument.
    
    Specified by:
    
    tan in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    tangent
  - asin
```
public SqmFunction<Double> asin(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the inverse sine of its argument.
    
    Specified by:
    
    asin in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    inverse sine
  - acos
```
public SqmFunction<Double> acos(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the inverse cosine of its argument.
    
    Specified by:
    
    acos in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    inverse cosine
  - atan
```
public SqmFunction<Double> atan(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the inverse tangent of its argument.
    
    Specified by:
    
    atan in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    inverse tangent
  - atan2
```
public SqmFunction<Double> atan2(Number y,
                                 Expression<? extends Number> x)
```
    Specified by:
    
    atan2 in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.atan2(Expression, Expression)
  - atan2
```
public SqmFunction<Double> atan2(Expression<? extends Number> y,
                                 Number x)
```
    Specified by:
    
    atan2 in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.atan2(Expression, Expression)
  - atan2
```
public SqmFunction<Double> atan2(Expression<? extends Number> y,
                                 Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the inverse tangent of y over x.
    
    Specified by:
    
    atan2 in interface HibernateCriteriaBuilder
    
    Parameters:
    
    y - y coordinate
    
    x - x coordinate
    
    Returns:
    
    2-argument inverse tangent
  - sinh
```
public SqmFunction<Double> sinh(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the hyperbolic sine of its argument.
    
    Specified by:
    
    sinh in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    hyperbolic sine
  - cosh
```
public SqmFunction<Double> cosh(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the hyperbolic cosine of its argument.
    
    Specified by:
    
    cosh in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    hyperbolic cosine
  - tanh
```
public SqmFunction<Double> tanh(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that returns the hyperbolic tangent of its argument.
    
    Specified by:
    
    tanh in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    hyperbolic tangent
  - degrees
```
public SqmFunction<Double> degrees(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that converts an angle measured in radians to an approximately equivalent angle measured in degrees.
    
    Specified by:
    
    degrees in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    degrees
  - radians
```
public SqmFunction<Double> radians(Expression<? extends Number> x)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an expression that converts an angle measured in degrees to an approximately equivalent angle measured in radians.
    
    Specified by:
    
    radians in interface HibernateCriteriaBuilder
    
    Parameters:
    
    x - expression
    
    Returns:
    
    radians
  - createWindow
```
public SqmWindow createWindow()
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an empty JpaWindow to use with window and aggregate functions.
    
    Specified by:
    
    createWindow in interface HibernateCriteriaBuilder
    
    Returns:
    
    the empty window
  - frameUnboundedPreceding
```
public SqmWindowFrame frameUnboundedPreceding()
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a window frame of type FrameKind.UNBOUNDED_PRECEDING to use with JpaWindows.
    
    Specified by:
    
    frameUnboundedPreceding in interface HibernateCriteriaBuilder
    
    Returns:
    
    the window frame
  - frameBetweenPreceding
```
public SqmWindowFrame frameBetweenPreceding(int offset)
```
    Specified by:
    
    frameBetweenPreceding in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.frameBetweenPreceding(Expression)
  - frameBetweenPreceding
```
public SqmWindowFrame frameBetweenPreceding(Expression<?> offset)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create window frame of type FrameKind.OFFSET_PRECEDING to use with JpaWindows.
    
    Specified by:
    
    frameBetweenPreceding in interface HibernateCriteriaBuilder
    
    Parameters:
    
    offset - the offset expression
    
    Returns:
    
    the window frame
  - frameCurrentRow
```
public SqmWindowFrame frameCurrentRow()
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a window frame of type FrameKind.CURRENT_ROW to use with JpaWindows.
    
    Specified by:
    
    frameCurrentRow in interface HibernateCriteriaBuilder
    
    Returns:
    
    the window frame
  - frameBetweenFollowing
```
public SqmWindowFrame frameBetweenFollowing(int offset)
```
    Specified by:
    
    frameBetweenFollowing in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.frameBetweenFollowing(Expression)
  - frameBetweenFollowing
```
public SqmWindowFrame frameBetweenFollowing(Expression<?> offset)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a window frame of type FrameKind.OFFSET_FOLLOWING to use with JpaWindows.
    
    Specified by:
    
    frameBetweenFollowing in interface HibernateCriteriaBuilder
    
    Parameters:
    
    offset - the offset expression
    
    Returns:
    
    the window frame
  - frameUnboundedFollowing
```
public SqmWindowFrame frameUnboundedFollowing()
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a window frame of type FrameKind.UNBOUNDED_FOLLOWING to use with JpaWindows.
    
    Specified by:
    
    frameUnboundedFollowing in interface HibernateCriteriaBuilder
    
    Returns:
    
    the window frame
  - windowFunction
```
public <T> SqmExpression<T> windowFunction(String name,
                                           Class<T> type,
                                           JpaWindow window,
                                           Expression<?>... args)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a generic window function expression that will be applied over the specified window.
    
    Specified by:
    
    windowFunction in interface HibernateCriteriaBuilder
    
    Type Parameters:
    
    T - type of this expression
    
    Parameters:
    
    name - name of the window function
    
    type - type of this expression
    
    window - window over which the function will be applied
    
    args - arguments to the function
    
    Returns:
    
    window function expression
  - rowNumber
```
public SqmExpression<Long> rowNumber(JpaWindow window)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a row_number window function expression.
    
    Specified by:
    
    rowNumber in interface HibernateCriteriaBuilder
    
    Parameters:
    
    window - window over which the function will be applied
    
    Returns:
    
    window function expression
    
    See Also:
    
    HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)
  - firstValue
```
public <T> SqmExpression<T> firstValue(Expression<T> argument,
                                       JpaWindow window)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a first_value window function expression.
    
    Specified by:
    
    firstValue in interface HibernateCriteriaBuilder
    
    Type Parameters:
    
    T - type of the expression
    
    Parameters:
    
    argument - argument expression to pass to first_value
    
    window - window over which the function will be applied
    
    Returns:
    
    window function expression
    
    See Also:
    
    HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)
  - lastValue
```
public <T> SqmExpression<T> lastValue(Expression<T> argument,
                                      JpaWindow window)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a last_value window function expression.
    
    Specified by:
    
    lastValue in interface HibernateCriteriaBuilder
    
    Type Parameters:
    
    T - type of the expression
    
    Parameters:
    
    argument - argument expression to pass to last_value
    
    window - window over which the function will be applied
    
    Returns:
    
    window function expression
    
    See Also:
    
    HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)
  - nthValue
```
public <T> SqmExpression<T> nthValue(Expression<T> argument,
                                     int n,
                                     JpaWindow window)
```
    Specified by:
    
    nthValue in interface HibernateCriteriaBuilder
    
    See Also:
    
    nthValue
  - nthValue
```
public <T> SqmExpression<T> nthValue(Expression<T> argument,
                                     Expression<Integer> n,
                                     JpaWindow window)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a nth_value window function expression.
    
    Specified by:
    
    nthValue in interface HibernateCriteriaBuilder
    
    Type Parameters:
    
    T - type of the expression
    
    Parameters:
    
    argument - argument expression to pass to nth_value
    
    n - the N argument for the function
    
    window - window over which the function will be applied
    
    Returns:
    
    window function expression
    
    See Also:
    
    HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)
  - rank
```
public SqmExpression<Long> rank(JpaWindow window)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a rank window function expression.
    
    Specified by:
    
    rank in interface HibernateCriteriaBuilder
    
    Parameters:
    
    window - window over which the function will be applied
    
    Returns:
    
    window function expression
    
    See Also:
    
    HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)
  - denseRank
```
public SqmExpression<Long> denseRank(JpaWindow window)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a dense_rank window function expression.
    
    Specified by:
    
    denseRank in interface HibernateCriteriaBuilder
    
    Parameters:
    
    window - window over which the function will be applied
    
    Returns:
    
    window function expression
    
    See Also:
    
    HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)
  - percentRank
```
public SqmExpression<Double> percentRank(JpaWindow window)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a percent_rank window function expression.
    
    Specified by:
    
    percentRank in interface HibernateCriteriaBuilder
    
    Parameters:
    
    window - window over which the function will be applied
    
    Returns:
    
    window function expression
    
    See Also:
    
    HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)
  - cumeDist
```
public SqmExpression<Double> cumeDist(JpaWindow window)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a cume_dist window function expression.
    
    Specified by:
    
    cumeDist in interface HibernateCriteriaBuilder
    
    Parameters:
    
    window - window over which the function will be applied
    
    Returns:
    
    window function expression
    
    See Also:
    
    HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)
  - functionAggregate
```
public <T> SqmExpression<T> functionAggregate(String name,
                                              Class<T> type,
                                              JpaPredicate filter,
                                              Expression<?>... args)
```
    Specified by:
    
    functionAggregate in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.functionAggregate(String, Class, JpaPredicate, JpaWindow, Expression...)
  - functionAggregate
```
public <T> SqmExpression<T> functionAggregate(String name,
                                              Class<T> type,
                                              JpaWindow window,
                                              Expression<?>... args)
```
    Specified by:
    
    functionAggregate in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.functionAggregate(String, Class, JpaPredicate, JpaWindow, Expression...)
  - functionAggregate
```
public <T> SqmExpression<T> functionAggregate(String name,
                                              Class<T> type,
                                              JpaPredicate filter,
                                              JpaWindow window,
                                              Expression<?>... args)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a generic aggregate function expression.
    
    Specified by:
    
    functionAggregate in interface HibernateCriteriaBuilder
    
    Type Parameters:
    
    T - type of this expression
    
    Parameters:
    
    name - name of the ordered set-aggregate function
    
    type - type of this expression
    
    filter - optional filter clause
    
    window - optional window over which to apply the function
    
    args - optional arguments to the function
    
    Returns:
    
    aggregate function expression
  - sum
```
public <N extends Number> SqmExpression<Number> sum(Expression<N> argument,
                                                    JpaPredicate filter)
```
    Specified by:
    
    sum in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.sum(Expression, JpaPredicate, JpaWindow)
  - sum
```
public <N extends Number> SqmExpression<Number> sum(Expression<N> argument,
                                                    JpaWindow window)
```
    Specified by:
    
    sum in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.sum(Expression, JpaPredicate, JpaWindow)
  - sum
```
public <N extends Number> SqmExpression<Number> sum(Expression<N> argument,
                                                    JpaPredicate filter,
                                                    JpaWindow window)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a sum aggregate function expression.
    
    Specified by:
    
    sum in interface HibernateCriteriaBuilder
    
    Type Parameters:
    
    N - type of the input expression
    
    Parameters:
    
    argument - argument to the function
    
    filter - optional filter clause
    
    window - optional window over which to apply the function
    
    Returns:
    
    aggregate function expression
    
    See Also:
    
    HibernateCriteriaBuilder.functionAggregate(String, Class, JpaPredicate, JpaWindow, Expression...)
  - avg
```
public <N extends Number> SqmExpression<Double> avg(Expression<N> argument,
                                                    JpaPredicate filter)
```
    Specified by:
    
    avg in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.avg(Expression, JpaPredicate, JpaWindow)
  - avg
```
public <N extends Number> SqmExpression<Double> avg(Expression<N> argument,
                                                    JpaWindow window)
```
    Specified by:
    
    avg in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.avg(Expression, JpaPredicate, JpaWindow)
  - avg
```
public <N extends Number> SqmExpression<Double> avg(Expression<N> argument,
                                                    JpaPredicate filter,
                                                    JpaWindow window)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create an avg aggregate function expression.
    
    Specified by:
    
    avg in interface HibernateCriteriaBuilder
    
    Type Parameters:
    
    N - type of the input expression
    
    Parameters:
    
    argument - argument to the function
    
    filter - optional filter clause
    
    window - optional window over which to apply the function
    
    Returns:
    
    aggregate function expression
    
    See Also:
    
    HibernateCriteriaBuilder.functionAggregate(String, Class, JpaPredicate, JpaWindow, Expression...)
  - count
```
public SqmExpression<Long> count(Expression<?> argument,
                                 JpaPredicate filter)
```
    Specified by:
    
    count in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.count(Expression, JpaPredicate, JpaWindow)
  - count
```
public SqmExpression<Long> count(Expression<?> argument,
                                 JpaWindow window)
```
    Specified by:
    
    count in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.count(Expression, JpaPredicate, JpaWindow)
  - count
```
public SqmExpression<Long> count(Expression<?> argument,
                                 JpaPredicate filter,
                                 JpaWindow window)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a count aggregate function expression.
    
    Specified by:
    
    count in interface HibernateCriteriaBuilder
    
    Parameters:
    
    argument - argument to the function
    
    filter - optional filter clause
    
    window - optional window over which to apply the function
    
    Returns:
    
    aggregate function expression
    
    See Also:
    
    HibernateCriteriaBuilder.functionAggregate(String, Class, JpaPredicate, JpaWindow, Expression...)
  - functionWithinGroup
```
public <T> SqmExpression<T> functionWithinGroup(String name,
                                                Class<T> type,
                                                JpaOrder order,
                                                Expression<?>... args)
```
    Specified by:
    
    functionWithinGroup in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - functionWithinGroup
```
public <T> SqmExpression<T> functionWithinGroup(String name,
                                                Class<T> type,
                                                JpaOrder order,
                                                JpaPredicate filter,
                                                Expression<?>... args)
```
    Specified by:
    
    functionWithinGroup in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - functionWithinGroup
```
public <T> SqmExpression<T> functionWithinGroup(String name,
                                                Class<T> type,
                                                JpaOrder order,
                                                JpaWindow window,
                                                Expression<?>... args)
```
    Specified by:
    
    functionWithinGroup in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - functionWithinGroup
```
public <T> SqmExpression<T> functionWithinGroup(String name,
                                                Class<T> type,
                                                JpaOrder order,
                                                JpaPredicate filter,
                                                JpaWindow window,
                                                Expression<?>... args)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a generic ordered set-aggregate function expression.
    
    Specified by:
    
    functionWithinGroup in interface HibernateCriteriaBuilder
    
    Type Parameters:
    
    T - type of this expression
    
    Parameters:
    
    name - name of the ordered set-aggregate function
    
    type - type of this expression
    
    order - order by clause used in within group
    
    filter - optional filter clause
    
    window - optional window over which to apply the function
    
    args - optional arguments to the function
    
    Returns:
    
    ordered set-aggregate function expression
  - listagg
```
public SqmExpression<String> listagg(JpaOrder order,
                                     Expression<String> argument,
                                     String separator)
```
    Specified by:
    
    listagg in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)
  - listagg
```
public SqmExpression<String> listagg(JpaOrder order,
                                     Expression<String> argument,
                                     Expression<String> separator)
```
    Specified by:
    
    listagg in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)
  - listagg
```
public SqmExpression<String> listagg(JpaOrder order,
                                     JpaPredicate filter,
                                     Expression<String> argument,
                                     String separator)
```
    Specified by:
    
    listagg in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)
  - listagg
```
public SqmExpression<String> listagg(JpaOrder order,
                                     JpaPredicate filter,
                                     Expression<String> argument,
                                     Expression<String> separator)
```
    Specified by:
    
    listagg in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)
  - listagg
```
public SqmExpression<String> listagg(JpaOrder order,
                                     JpaWindow window,
                                     Expression<String> argument,
                                     String separator)
```
    Specified by:
    
    listagg in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)
  - listagg
```
public SqmExpression<String> listagg(JpaOrder order,
                                     JpaWindow window,
                                     Expression<String> argument,
                                     Expression<String> separator)
```
    Specified by:
    
    listagg in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)
  - listagg
```
public SqmExpression<String> listagg(JpaOrder order,
                                     JpaPredicate filter,
                                     JpaWindow window,
                                     Expression<String> argument,
                                     String separator)
```
    Specified by:
    
    listagg in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)
  - listagg
```
public SqmExpression<String> listagg(JpaOrder order,
                                     JpaPredicate filter,
                                     JpaWindow window,
                                     Expression<String> argument,
                                     Expression<String> separator)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a listagg ordered set-aggregate function expression.
    
    Specified by:
    
    listagg in interface HibernateCriteriaBuilder
    
    Parameters:
    
    order - order by clause used in within group
    
    filter - optional filter clause
    
    window - optional window over which to apply the function
    
    argument - values to join
    
    separator - the separator used to join the values
    
    Returns:
    
    ordered set-aggregate expression
    
    See Also:
    
    HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - mode
```
public <T> SqmExpression<T> mode(Expression<T> sortExpression,
                                 SortOrder sortOrder,
                                 NullPrecedence nullPrecedence)
```
    Specified by:
    
    mode in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.mode(JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)
  - mode
```
public <T> SqmExpression<T> mode(JpaPredicate filter,
                                 Expression<T> sortExpression,
                                 SortOrder sortOrder,
                                 NullPrecedence nullPrecedence)
```
    Specified by:
    
    mode in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.mode(JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)
  - mode
```
public <T> SqmExpression<T> mode(JpaWindow window,
                                 Expression<T> sortExpression,
                                 SortOrder sortOrder,
                                 NullPrecedence nullPrecedence)
```
    Specified by:
    
    mode in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.mode(JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)
  - mode
```
public <T> SqmExpression<T> mode(JpaPredicate filter,
                                 JpaWindow window,
                                 Expression<T> sortExpression,
                                 SortOrder sortOrder,
                                 NullPrecedence nullPrecedence)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a mode ordered set-aggregate function expression.
    
    Specified by:
    
    mode in interface HibernateCriteriaBuilder
    
    Type Parameters:
    
    T - type of this expression
    
    Parameters:
    
    filter - optional filter clause
    
    window - optional window over which to apply the function
    
    sortExpression - the sort expression
    
    sortOrder - the sort order
    
    nullPrecedence - the null precedence
    
    Returns:
    
    ordered set-aggregate expression
    
    See Also:
    
    HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - percentileCont
```
public <T> SqmExpression<T> percentileCont(Expression<? extends Number> argument,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)
```
    Specified by:
    
    percentileCont in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.percentileCont(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)
  - percentileCont
```
public <T> SqmExpression<T> percentileCont(Expression<? extends Number> argument,
                                           JpaPredicate filter,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)
```
    Specified by:
    
    percentileCont in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.percentileCont(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)
  - percentileCont
```
public <T> SqmExpression<T> percentileCont(Expression<? extends Number> argument,
                                           JpaWindow window,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)
```
    Specified by:
    
    percentileCont in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.percentileCont(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)
  - percentileCont
```
public <T> SqmExpression<T> percentileCont(Expression<? extends Number> argument,
                                           JpaPredicate filter,
                                           JpaWindow window,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a percentile_cont ordered set-aggregate function expression.
    
    Specified by:
    
    percentileCont in interface HibernateCriteriaBuilder
    
    Parameters:
    
    argument - argument to the function
    
    filter - optional filter clause
    
    window - optional window over which to apply the function
    
    sortExpression - the sort expression
    
    sortOrder - the sort order
    
    nullPrecedence - the null precedence
    
    Returns:
    
    ordered set-aggregate expression
    
    See Also:
    
    HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - percentileDisc
```
public <T> SqmExpression<T> percentileDisc(Expression<? extends Number> argument,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)
```
    Specified by:
    
    percentileDisc in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.percentileDisc(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)
  - percentileDisc
```
public <T> SqmExpression<T> percentileDisc(Expression<? extends Number> argument,
                                           JpaPredicate filter,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)
```
    Specified by:
    
    percentileDisc in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.percentileDisc(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)
  - percentileDisc
```
public <T> SqmExpression<T> percentileDisc(Expression<? extends Number> argument,
                                           JpaWindow window,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)
```
    Specified by:
    
    percentileDisc in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.percentileDisc(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)
  - percentileDisc
```
public <T> SqmExpression<T> percentileDisc(Expression<? extends Number> argument,
                                           JpaPredicate filter,
                                           JpaWindow window,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a percentile_disc ordered set-aggregate function expression.
    
    Specified by:
    
    percentileDisc in interface HibernateCriteriaBuilder
    
    Parameters:
    
    argument - argument to the function
    
    filter - optional filter clause
    
    window - optional window over which to apply the function
    
    sortExpression - the sort expression
    
    sortOrder - the sort order
    
    nullPrecedence - the null precedence
    
    Returns:
    
    ordered set-aggregate expression
    
    See Also:
    
    HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - rank
```
public SqmExpression<Long> rank(JpaOrder order,
                                Expression<?>... arguments)
```
    Specified by:
    
    rank in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.rank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - rank
```
public SqmExpression<Long> rank(JpaOrder order,
                                JpaPredicate filter,
                                Expression<?>... arguments)
```
    Specified by:
    
    rank in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.rank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - rank
```
public SqmExpression<Long> rank(JpaOrder order,
                                JpaWindow window,
                                Expression<?>... arguments)
```
    Specified by:
    
    rank in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.rank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - rank
```
public SqmExpression<Long> rank(JpaOrder order,
                                JpaPredicate filter,
                                JpaWindow window,
                                Expression<?>... arguments)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a rank ordered set-aggregate function expression.
    
    Specified by:
    
    rank in interface HibernateCriteriaBuilder
    
    Parameters:
    
    order - order by clause used in within group
    
    filter - optional filter clause
    
    window - optional window over which to apply the function
    
    arguments - arguments to the function
    
    Returns:
    
    ordered set-aggregate expression
    
    See Also:
    
    HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - percentRank
```
public SqmExpression<Double> percentRank(JpaOrder order,
                                         Expression<?>... arguments)
```
    Specified by:
    
    percentRank in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.percentRank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - percentRank
```
public SqmExpression<Double> percentRank(JpaOrder order,
                                         JpaPredicate filter,
                                         Expression<?>... arguments)
```
    Specified by:
    
    percentRank in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.percentRank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - percentRank
```
public SqmExpression<Double> percentRank(JpaOrder order,
                                         JpaWindow window,
                                         Expression<?>... arguments)
```
    Specified by:
    
    percentRank in interface HibernateCriteriaBuilder
    
    See Also:
    
    HibernateCriteriaBuilder.percentRank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
  - percentRank
```
public SqmExpression<Double> percentRank(JpaOrder order,
                                         JpaPredicate filter,
                                         JpaWindow window,
                                         Expression<?>... arguments)
```
    Description copied from interface: HibernateCriteriaBuilder
    
    Create a percent_rank ordered set-aggregate function expression.
    
    Specified by:
    
    percentRank in interface HibernateCriteriaBuilder
    
    Parameters:
    
    order - order by clause used in within group
    
    filter - optional filter clause
    
    window - optional window over which to apply the function
    
    arguments - arguments to the function
    
    Returns:
    
    ordered set-aggregate expression
    
    See Also:
    
    HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)

Class SqmCriteriaNodeBuilder

Nested Class Summary

Nested classes/interfaces inherited from interface jakarta.persistence.criteria.CriteriaBuilder

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Methods inherited from interface org.hibernate.query.criteria.HibernateCriteriaBuilder

Methods inherited from interface org.hibernate.query.sqm.spi.SqmCreationContext

Constructor Detail

SqmCriteriaNodeBuilder

Method Detail

getDomainModel

getTypeConfiguration

isJpaQueryComplianceEnabled

getSessionFactory

areTypesComparable

getBooleanType

getIntegerType

getCharacterType

getServiceRegistry

getQueryEngine

getJpaMetamodel

close

createQuery

createQuery

createTupleQuery

createCriteriaUpdate

createCriteriaDelete

createCriteriaInsertSelect

union

intersect

except

union

intersect

except

cast

wrap

wrap

unwrap

fk

treat

treat

treat

treat

treat

treat

treat

sort

sort

sort

asc

desc

asc

desc

search

search

search

asc

desc

asc

desc

tuple

tuple

tuple

tuple

tuple

tuple

array

array

array

array

construct

construct

avg

sum

sumAsLong

sumAsDouble

max

min

greatest