SqlExpressionBuilder

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

Link copied to clipboard
open fun <T, S : T?> ExpressionWithColumnType<S>.asLiteral(value: T): LiteralOp<T>
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
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
open fun case(): Case
open fun <T> case(value: ExpressionWithColumnType<T>): ValueCase<T>
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>
Link copied to clipboard
open fun concat(vararg expr: Expression<*>): Concat
open fun concat(separator: String = "", expr: List<Expression<*>>): Concat
Link copied to clipboard
open fun cumeDist(): CumeDist
Link copied to clipboard
open fun denseRank(): DenseRank
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>
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>
Link copied to clipboard
open infix fun <T> Expression<T>.eqSubQuery(query: AbstractQuery<*>): EqSubQueryOp<T>
Link copied to clipboard
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
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>, 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
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
open infix fun <T> ExpressionWithColumnType<T>.hasFlag(t: T): EqOp
Link copied to clipboard
Link copied to clipboard
open infix fun <T> Expression<T>.inSubQuery(query: AbstractQuery<*>): InSubQueryOp<T>
Link copied to clipboard
open infix fun <T> ExpressionWithColumnType<T>.inTable(table: Table): InTableOp
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?> Expression<in S>.isDistinctFrom(other: Expression<in S>): IsDistinctFromOp
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?> Expression<in S>.isNotDistinctFrom(other: Expression<in S>): IsNotDistinctFromOp
Link copied to clipboard
open fun <T> Expression<T>.isNotNull(): Op<Boolean>
Link copied to clipboard
open fun <T> Expression<T>.isNull(): Op<Boolean>
Link copied to clipboard
Link copied to clipboard
open fun <T> ExpressionWithColumnType<T>.lag(offset: ExpressionWithColumnType<Int> = intLiteral(1), defaultValue: ExpressionWithColumnType<T>? = null): Lag<T>
Link copied to clipboard
Link copied to clipboard
open fun <T> ExpressionWithColumnType<T>.lead(offset: ExpressionWithColumnType<Int> = intLiteral(1), defaultValue: ExpressionWithColumnType<T>? = null): Lead<T>
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
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
Link copied to clipboard
Link copied to clipboard
open infix fun <T> Expression<T>.lessSubQuery(query: AbstractQuery<*>): LessSubQueryOp<T>
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
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>
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>
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>
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>
Link copied to clipboard
open infix fun <T> Expression<T>.notEqSubQuery(query: AbstractQuery<*>): NotEqSubQueryOp<T>
Link copied to clipboard
Link copied to clipboard
open infix fun <T> Expression<T>.notInSubQuery(query: AbstractQuery<*>): NotInSubQueryOp<T>
Link copied to clipboard
Link copied to clipboard
open infix fun <T : String?> Expression<T>.notLike(pattern: 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
Link copied to clipboard
Link copied to clipboard
open fun ntile(numBuckets: ExpressionWithColumnType<Int>): Ntile
Link copied to clipboard
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
Link copied to clipboard
open fun rank(): Rank
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>
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>
Link copied to clipboard
open fun rowNumber(): RowNumber
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>
Link copied to clipboard
open fun <T, S : T?> ExpressionWithColumnType<in S>.wrap(value: T): QueryParameter<T>