MssqlExpressionOperators extension

The comparison and predicate operators, on any expression.

They hang off MssqlExpression rather than off columns alone so that an aggregate can be compared too: having(sum(Col('Total')).gt(1000)).

on

• MssqlExpression

Methods

as(String alias) → MssqlAliased

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

Gives this expression a result alias.

asc({MssqlNulls? nulls}) → MssqlOrder

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

Orders by this expression, ascending.

between(Object? lower, Object? upper) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

betweenColumns(String lower, String upper) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

BETWEEN two other columns rather than two values.

desc({MssqlNulls? nulls}) → MssqlOrder

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

Orders by this expression, descending.

eq(Object? value) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

eqCol(String identifier) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

Compares this expression to another column rather than to a value.

eqExpr(MssqlExpression other) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

Compares this expression to another expression.

gt(Object? value) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

gte(Object? value) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

inList(Iterable<Object?> values) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

isNotNull() → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

isNull() → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

lt(Object? value) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

lte(Object? value) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

ne(Object? value) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

notBetween(Object? lower, Object? upper) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

notBetweenColumns(String lower, String upper) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

notInList(Iterable<Object?> values) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

whereAfterToday() → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

whereBeforeToday() → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

whereDate(Object? value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

Compares the date alone, so the whole day matches rather than midnight.

whereDay(int value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

whereFuture() → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

whereMonth(int value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

whereNowOrFuture() → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

whereNowOrPast() → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

wherePast() → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

Strictly earlier than now, again by the server's clock.

whereTime(Object? value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

Compares the time of day, with the date discarded.

whereToday() → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

The date part equals today, as the server reckons it.

whereTodayOrAfter() → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

whereTodayOrBefore() → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension

whereYear(int value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition

Available on MssqlExpression, provided by the MssqlExpressionOperators extension