# SqlExpressionBuilder

object SqlExpressionBuilder : ISqlExpressionBuilder

### Deprecated (with error)

This builder object will continue to be phased out following release 1.0.0. All expression builder methods previously restricted to this object have also been deprecated in favor of equivalent top-level functions, making this object useless as a receiver in any scope. It will no longer be necessary to import each individual method when used outside a scoped block, and on demand imports will now be possible via 'import org.jetbrains.exposed.v1.core.*', if required.

## Functions

asLiteral
Link copied to clipboard
open fun <T, S : T?> ExpressionWithColumnType<S>.asLiteral(value: T): LiteralOp<T>
between
Link copied to clipboard
open fun <T : Any, E : EntityID<T>?> Column<E>.between(from: T, to: T): Between
open fun <T, S : T?> ExpressionWithColumnType<in S>.between(from: T, to: T): Between
bitwiseAnd
Link copied to clipboard
open infix fun <T> ExpressionWithColumnType<T>.bitwiseAnd(t: T): AndBitOp<T, T>
open infix fun <T> ExpressionWithColumnType<T>.bitwiseAnd(t: Expression<T>): AndBitOp<T, T>
bitwiseOr
Link copied to clipboard
open infix fun <T> ExpressionWithColumnType<T>.bitwiseOr(t: T): OrBitOp<T, T>
open infix fun <T> ExpressionWithColumnType<T>.bitwiseOr(t: Expression<T>): OrBitOp<T, T>
bitwiseXor
Link copied to clipboard
open infix fun <T> ExpressionWithColumnType<T>.bitwiseXor(t: T): XorBitOp<T, T>
open infix fun <T> ExpressionWithColumnType<T>.bitwiseXor(t: Expression<T>): XorBitOp<T, T>
case
Link copied to clipboard
open fun case(): Case
open fun <T> case(value: ExpressionWithColumnType<T>): ValueCase<T>
coalesce
Link copied to clipboard
open fun <T, S : T?> coalesce(expr: ExpressionWithColumnType<S>, alternate: Expression<out T>, vararg others: Expression<out T>): Coalesce<T, S>
concat
Link copied to clipboard
open fun concat(vararg expr: Expression<*>): Concat
open fun concat(separator: String = "", expr: List<Expression<*>>): Concat
cumeDist
Link copied to clipboard
open fun cumeDist(): CumeDist
denseRank
Link copied to clipboard
open fun denseRank(): DenseRank
div
Link copied to clipboard
open infix operator fun <T> ExpressionWithColumnType<T>.div(t: T): DivideOp<T, T>
open infix operator fun <T, S : T> ExpressionWithColumnType<T>.div(other: Expression<S>): DivideOp<T, S>
eq
Link copied to clipboard
open infix fun <T> CompositeColumn<T>.eq(t: T): Op<Boolean>
open infix fun <T> ExpressionWithColumnType<T>.eq(t: T): Op<Boolean>
@JvmName(name = "eqEntityIDValue")
open infix fun <T : Any, E : EntityID<T>?, V : T?> ExpressionWithColumnType<E>.eq(t: V): Op<Boolean>
open infix fun <T : Any, E : EntityID<T>?, V : T?> ExpressionWithColumnType<E>.eq(other: Expression<V>): Op<Boolean>
open infix fun <T, S1 : T?, S2 : T?> Expression<in S1>.eq(other: Expression<in S2>): Op<Boolean>
open infix fun <T : Any, V : T?, E : EntityID<T>?> Expression<V>.eq(other: ExpressionWithColumnType<E>): Op<Boolean>
eqSubQuery
Link copied to clipboard
open infix fun <T> Expression<T>.eqSubQuery(query: AbstractQuery<*>): EqSubQueryOp<T>
firstValue
Link copied to clipboard
open fun <T> ExpressionWithColumnType<T>.firstValue(): FirstValue<T>
greater
Link copied to clipboard
@JvmName(name = "greaterEntityID")
open infix fun <T : Comparable<T>> Column<EntityID<T>>.greater(t: T): GreaterOp
open infix fun <T : Comparable<T>, S : T?> ExpressionWithColumnType<in S>.greater(t: T): GreaterOp
open infix fun <T : Comparable<T>, E : EntityID<T>?, V : T?> ExpressionWithColumnType<E>.greater(other: Expression<in V>): GreaterOp
open infix fun <T : Comparable<T>, V : T?, E : EntityID<T>?> Expression<V>.greater(other: ExpressionWithColumnType<E>): GreaterOp
open infix fun <T : Comparable<T>, S : T?> Expression<in S>.greater(other: Expression<in S>): GreaterOp
@JvmName(name = "greaterBetweenEntityIDs")
open infix fun <T : Comparable<T>, E : EntityID<T>?> Expression<E>.greater(other: Expression<E>): GreaterOp
greaterEq
Link copied to clipboard
@JvmName(name = "greaterEqEntityID")
open infix fun <T : Comparable<T>> Column<EntityID<T>>.greaterEq(t: T): GreaterEqOp
open infix fun <T : Comparable<T>, S : T?> ExpressionWithColumnType<in S>.greaterEq(t: T): GreaterEqOp
open infix fun <T : Comparable<T>, E : EntityID<T>?, V : T?> ExpressionWithColumnType<E>.greaterEq(other: Expression<in V>): GreaterEqOp
open infix fun <T : Comparable<T>, V : T?, E : EntityID<T>?> Expression<V>.greaterEq(other: ExpressionWithColumnType<E>): GreaterEqOp
open infix fun <T : Comparable<T>, S : T?> Expression<in S>.greaterEq(other: Expression<in S>): GreaterEqOp
@JvmName(name = "greaterEqBetweenEntityIDs")
open infix fun <T : Comparable<T>, E : EntityID<T>?> Expression<E>.greaterEq(other: Expression<E>): GreaterEqOp
greaterEqSubQuery
Link copied to clipboard
open infix fun <T> Expression<T>.greaterEqSubQuery(query: AbstractQuery<*>): GreaterEqSubQueryOp<T>
greaterSubQuery
Link copied to clipboard
open infix fun <T> Expression<T>.greaterSubQuery(query: AbstractQuery<*>): GreaterSubQueryOp<T>
hasFlag
Link copied to clipboard
open infix fun <T> ExpressionWithColumnType<T>.hasFlag(t: T): EqOp
open infix fun <T> ExpressionWithColumnType<T>.hasFlag(t: Expression<T>): EqOp
inList
Link copied to clipboard
open infix fun <T1, T2> Pair<ExpressionWithColumnType<T1>, ExpressionWithColumnType<T2>>.inList(list: Iterable<Pair<T1, T2>>): InListOrNotInListBaseOp<Pair<T1, T2>>
open infix fun <T1, T2, T3> Triple<ExpressionWithColumnType<T1>, ExpressionWithColumnType<T2>, ExpressionWithColumnType<T3>>.inList(list: Iterable<Triple<T1, T2, T3>>): InListOrNotInListBaseOp<Triple<T1, T2, T3>>
open infix fun List<Column<*>>.inList(list: Iterable<List<*>>): InListOrNotInListBaseOp<List<*>>
@JvmName(name = "inListCompositeIDs")
open infix fun List<Column<*>>.inList(list: Iterable<CompositeID>): InListOrNotInListBaseOp<List<*>>
@JvmName(name = "inListIds")
open infix fun <T : Any, ID : EntityID<T>?> Column<ID>.inList(list: Iterable<T>): InListOrNotInListBaseOp<EntityID<T>?>
@JvmName(name = "inListCompositeEntityIds")
open infix fun <ID : EntityID<CompositeID>> Column<ID>.inList(list: Iterable<CompositeID>): InListOrNotInListBaseOp<List<*>>
open infix fun <T> ExpressionWithColumnType<T>.inList(list: Iterable<T>): InListOrNotInListBaseOp<T>
inSubQuery
Link copied to clipboard
open infix fun <T> Expression<T>.inSubQuery(query: AbstractQuery<*>): InSubQueryOp<T>
inTable
Link copied to clipboard
open infix fun <T> ExpressionWithColumnType<T>.inTable(table: Table): InTableOp
intToDecimal
Link copied to clipboard
open fun ExpressionWithColumnType<Int>.intToDecimal(): NoOpConversion<Int, BigDecimal>
isDistinctFrom
Link copied to clipboard
@JvmName(name = "isDistinctFromEntityID")
open infix fun <T : Any> Column<EntityID<T>>.isDistinctFrom(t: T): IsDistinctFromOp
open infix fun <T : Comparable<T>, S : T?> ExpressionWithColumnType<in S>.isDistinctFrom(t: T): IsDistinctFromOp
open infix fun <T : Any, E : EntityID<T>?, V : T?> ExpressionWithColumnType<E>.isDistinctFrom(other: Expression<in V>): IsDistinctFromOp
open infix fun <T : Any, V : T?, E : EntityID<T>?> Expression<in V>.isDistinctFrom(other: ExpressionWithColumnType<E>): IsDistinctFromOp
open infix fun <T : Comparable<T>, S : T?> Expression<in S>.isDistinctFrom(other: Expression<in S>): IsDistinctFromOp
isNotDistinctFrom
Link copied to clipboard
@JvmName(name = "isNotDistinctFromEntityID")
open infix fun <T : Any> Column<EntityID<T>>.isNotDistinctFrom(t: T): IsNotDistinctFromOp
open infix fun <T : Comparable<T>, S : T?> ExpressionWithColumnType<in S>.isNotDistinctFrom(t: T): IsNotDistinctFromOp
open infix fun <T : Any, E : EntityID<T>?, V : T?> ExpressionWithColumnType<E>.isNotDistinctFrom(other: Expression<in V>): IsNotDistinctFromOp
open infix fun <T : Any, V : T?, E : EntityID<T>?> Expression<V>.isNotDistinctFrom(other: ExpressionWithColumnType<E>): IsNotDistinctFromOp
open infix fun <T : Comparable<T>, S : T?> Expression<in S>.isNotDistinctFrom(other: Expression<in S>): IsNotDistinctFromOp
isNotNull
Link copied to clipboard
open fun <T> Expression<T>.isNotNull(): Op<Boolean>
isNull
Link copied to clipboard
open fun <T> Expression<T>.isNull(): Op<Boolean>
isNullOrEmpty
Link copied to clipboard
open fun <T : String?> Expression<T>.isNullOrEmpty(): Op<Boolean>
lag
Link copied to clipboard
open fun <T> ExpressionWithColumnType<T>.lag(offset: ExpressionWithColumnType<Int> = intLiteral(1), defaultValue: ExpressionWithColumnType<T>? = null): Lag<T>
lastValue
Link copied to clipboard
open fun <T> ExpressionWithColumnType<T>.lastValue(): LastValue<T>
lead
Link copied to clipboard
open fun <T> ExpressionWithColumnType<T>.lead(offset: ExpressionWithColumnType<Int> = intLiteral(1), defaultValue: ExpressionWithColumnType<T>? = null): Lead<T>
less
Link copied to clipboard
@JvmName(name = "lessEntityID")
open infix fun <T : Comparable<T>> Column<EntityID<T>>.less(t: T): LessOp
open infix fun <T : Comparable<T>, S : T?> ExpressionWithColumnType<in S>.less(t: T): LessOp
open infix fun <T : Comparable<T>, E : EntityID<T>?, V : T?> ExpressionWithColumnType<E>.less(other: Expression<in V>): LessOp
open infix fun <T : Comparable<T>, V : T?, E : EntityID<T>?> Expression<V>.less(other: ExpressionWithColumnType<E>): LessOp
open infix fun <T : Comparable<T>, S : T?> Expression<in S>.less(other: Expression<in S>): LessOp
@JvmName(name = "lessBetweenEntityIDs")
open infix fun <T : Comparable<T>, E : EntityID<T>?> Expression<E>.less(other: Expression<E>): LessOp
lessEq
Link copied to clipboard
@JvmName(name = "lessEqEntityID")
open infix fun <T : Comparable<T>> Column<EntityID<T>>.lessEq(t: T): LessEqOp
open infix fun <T : Comparable<T>, S : T?> ExpressionWithColumnType<in S>.lessEq(t: T): LessEqOp
open infix fun <T : Comparable<T>, E : EntityID<T>?, V : T?> ExpressionWithColumnType<E>.lessEq(other: Expression<in V>): LessEqOp
open infix fun <T : Comparable<T>, V : T?, E : EntityID<T>?> Expression<V>.lessEq(other: ExpressionWithColumnType<E>): LessEqOp
open infix fun <T : Comparable<T>, S : T?> Expression<in S>.lessEq(other: Expression<in S>): LessEqOp
@JvmName(name = "lessEqBetweenEntityIDs")
open infix fun <T : Comparable<T>, E : EntityID<T>?> Expression<E>.lessEq(other: Expression<E>): LessEqOp
lessEqSubQuery
Link copied to clipboard
open infix fun <T> Expression<T>.lessEqSubQuery(query: AbstractQuery<*>): LessEqSubQueryOp<T>
lessSubQuery
Link copied to clipboard
open infix fun <T> Expression<T>.lessSubQuery(query: AbstractQuery<*>): LessSubQueryOp<T>
like
Link copied to clipboard
open infix fun <T : String?> Expression<T>.like(pattern: String): LikeEscapeOp
open infix fun <T : String?> Expression<T>.like(expression: ExpressionWithColumnType<String>): LikeEscapeOp
open infix fun <T : String?> Expression<T>.like(pattern: LikePattern): LikeEscapeOp
@JvmName(name = "likeWithEntityID")
open infix fun Expression<EntityID<String>>.like(pattern: String): LikeEscapeOp
@JvmName(name = "likeWithEntityIDAndExpression")
open infix fun Expression<EntityID<String>>.like(expression: ExpressionWithColumnType<String>): LikeEscapeOp
@JvmName(name = "likeWithEntityID")
open infix fun Expression<EntityID<String>>.like(pattern: LikePattern): LikeEscapeOp
match
Link copied to clipboard
open infix fun <T : String?> Expression<T>.match(pattern: String): Op<Boolean>
open fun <T : String?> Expression<T>.match(pattern: String, mode: FunctionProvider.MatchMode?): Op<Boolean>
minus
Link copied to clipboard
open infix operator fun <T> ExpressionWithColumnType<T>.minus(t: T): MinusOp<T, T>
open infix operator fun <T, S : T> ExpressionWithColumnType<T>.minus(other: Expression<S>): MinusOp<T, S>
mod
Link copied to clipboard
open infix fun <T : Number?, S : T> ExpressionWithColumnType<T>.mod(t: S): ModOp<T, S, T>
open infix fun <T : Number?, S : Number> ExpressionWithColumnType<T>.mod(other: Expression<S>): ModOp<T, S, T>
@JvmName(name = "modWithEntityId")
open infix fun <T : Number, Comparable<T>, S : Number, ID : EntityID<T>?> ExpressionWithColumnType<ID>.mod(other: S): ExpressionWithColumnType<T>
@JvmName(name = "modWithEntityId3")
open infix fun <T : Number, Comparable<T>, S : Number, ID : EntityID<T>?> ExpressionWithColumnType<ID>.mod(other: Expression<S>): ExpressionWithColumnType<T>
@JvmName(name = "modWithEntityId2")
open infix fun <T : Number, Comparable<T>, S : Number, ID : EntityID<T>?> Expression<S>.mod(other: ExpressionWithColumnType<ID>): ExpressionWithColumnType<T>
neq
Link copied to clipboard
open infix fun <T> ExpressionWithColumnType<T>.neq(other: T): Op<Boolean>
@JvmName(name = "neqEntityIDValue")
open infix fun <T : Any, E : EntityID<T>?, V : T?> ExpressionWithColumnType<E>.neq(t: V): Op<Boolean>
open infix fun <T : Any, E : EntityID<T>?, V : T?> ExpressionWithColumnType<E>.neq(other: Expression<V>): Op<Boolean>
open infix fun <T, S1 : T?, S2 : T?> Expression<in S1>.neq(other: Expression<in S2>): Op<Boolean>
open infix fun <T : Any, V : T?, E : EntityID<T>?> Expression<V>.neq(other: ExpressionWithColumnType<E>): Op<Boolean>
notEqSubQuery
Link copied to clipboard
open infix fun <T> Expression<T>.notEqSubQuery(query: AbstractQuery<*>): NotEqSubQueryOp<T>
notInList
Link copied to clipboard
open infix fun <T1, T2> Pair<ExpressionWithColumnType<T1>, ExpressionWithColumnType<T2>>.notInList(list: Iterable<Pair<T1, T2>>): InListOrNotInListBaseOp<Pair<T1, T2>>
open infix fun <T1, T2, T3> Triple<ExpressionWithColumnType<T1>, ExpressionWithColumnType<T2>, ExpressionWithColumnType<T3>>.notInList(list: Iterable<Triple<T1, T2, T3>>): InListOrNotInListBaseOp<Triple<T1, T2, T3>>
open infix fun List<Column<*>>.notInList(list: Iterable<List<*>>): InListOrNotInListBaseOp<List<*>>
@JvmName(name = "notInListCompositeIDs")
open infix fun List<Column<*>>.notInList(list: Iterable<CompositeID>): InListOrNotInListBaseOp<List<*>>
@JvmName(name = "notInListIds")
open infix fun <T : Any, ID : EntityID<T>?> Column<ID>.notInList(list: Iterable<T>): InListOrNotInListBaseOp<EntityID<T>?>
@JvmName(name = "notInListCompositeEntityIds")
open infix fun <ID : EntityID<CompositeID>> Column<ID>.notInList(list: Iterable<CompositeID>): InListOrNotInListBaseOp<List<*>>
open infix fun <T> ExpressionWithColumnType<T>.notInList(list: Iterable<T>): InListOrNotInListBaseOp<T>
notInSubQuery
Link copied to clipboard
open infix fun <T> Expression<T>.notInSubQuery(query: AbstractQuery<*>): NotInSubQueryOp<T>
notInTable
Link copied to clipboard
open infix fun <T> ExpressionWithColumnType<T>.notInTable(table: Table): InTableOp
notLike
Link copied to clipboard
open infix fun <T : String?> Expression<T>.notLike(pattern: String): LikeEscapeOp
open infix fun <T : String?> Expression<T>.notLike(expression: ExpressionWithColumnType<String>): LikeEscapeOp
open infix fun <T : String?> Expression<T>.notLike(pattern: LikePattern): LikeEscapeOp
@JvmName(name = "notLikeWithEntityID")
open infix fun Expression<EntityID<String>>.notLike(pattern: String): LikeEscapeOp
@JvmName(name = "notLikeWithEntityIDAndExpression")
open infix fun Expression<EntityID<String>>.notLike(expression: ExpressionWithColumnType<String>): LikeEscapeOp
@JvmName(name = "notLikeWithEntityID")
open infix fun Expression<EntityID<String>>.notLike(pattern: LikePattern): LikeEscapeOp
nthValue
Link copied to clipboard
open fun <T> ExpressionWithColumnType<T>.nthValue(n: ExpressionWithColumnType<Int>): NthValue<T>
ntile
Link copied to clipboard
open fun ntile(numBuckets: ExpressionWithColumnType<Int>): Ntile
percentRank
Link copied to clipboard
open fun percentRank(): PercentRank
plus
Link copied to clipboard
open infix operator fun String.plus(value: Expression<String>): Concat
open infix operator fun <T> ExpressionWithColumnType<T>.plus(t: T): PlusOp<T, T>
open infix operator fun <T, S : T> ExpressionWithColumnType<T>.plus(other: Expression<S>): PlusOp<T, S>
open infix operator fun Expression<String>.plus(value: String): Concat
open infix operator fun Expression<String>.plus(value: Expression<String>): Concat
rank
Link copied to clipboard
open fun rank(): Rank
regexp
Link copied to clipboard
open infix fun <T : String?> Expression<T>.regexp(pattern: String): RegexpOp<T>
open fun <T : String?> Expression<T>.regexp(pattern: Expression<String>, caseSensitive: Boolean = true): RegexpOp<T>
rem
Link copied to clipboard
open infix operator fun <T : Number?, S : T> ExpressionWithColumnType<T>.rem(t: S): ModOp<T, S, T>
open infix operator fun <T : Number?, S : Number> ExpressionWithColumnType<T>.rem(other: Expression<S>): ModOp<T, S, T>
@JvmName(name = "remWithEntityId")
open infix operator fun <T : Number, Comparable<T>, S : Number, ID : EntityID<T>?> ExpressionWithColumnType<ID>.rem(other: S): ExpressionWithColumnType<T>
@JvmName(name = "remWithEntityId3")
open infix operator fun <T : Number, Comparable<T>, S : Number, ID : EntityID<T>?> ExpressionWithColumnType<ID>.rem(other: Expression<S>): ExpressionWithColumnType<T>
@JvmName(name = "remWithEntityId2")
open infix operator fun <T : Number, Comparable<T>, S : Number, ID : EntityID<T>?> Expression<S>.rem(other: ExpressionWithColumnType<ID>): ExpressionWithColumnType<T>
rowNumber
Link copied to clipboard
open fun rowNumber(): RowNumber
times
Link copied to clipboard
open infix operator fun <T> ExpressionWithColumnType<T>.times(t: T): TimesOp<T, T>
open infix operator fun <T, S : T> ExpressionWithColumnType<T>.times(other: Expression<S>): TimesOp<T, S>
wrap
Link copied to clipboard
open fun <T, S : T?> ExpressionWithColumnType<in S>.wrap(value: T): QueryParameter<T>