Functions

Returns an expression that evaluates the ABS SQL function.

// ABS(amount)
abs(Column("amount"))

Returns an expression that evaluates the AVG SQL function.

// AVG(length)
average(Column("length"))

Returns an expression that evaluates the COUNT SQL function.

// COUNT(email)
count(Column("email"))

Returns an expression that evaluates the COUNT(DISTINCT) SQL function.

// COUNT(DISTINCT email)
count(distinct: Column("email"))

Returns an expression that evaluates the IFNULL SQL function.

// IFNULL(name, 'Anonymous')
Column("name") ?? "Anonymous"

Returns an expression that evaluates the LENGTH SQL function.

// LENGTH(name)
length(Column("name"))

Returns an expression that evaluates the MAX SQL function.

// MAX(score)
max(Column("score"))

Returns an expression that evaluates the MIN SQL function.

// MIN(score)
min(Column("score"))

Returns an expression that evaluates the SUM SQL function.

// SUM(amount)
sum(Column("amount"))

An SQL expression that compares two expressions with the = SQL operator.

// name = 'Arthur'
Column("name") == "Arthur"

When the right operand is nil, IS NULL is used instead.

// name IS NULL
Column("name") == nil

An SQL expression that compares two expressions with the = SQL operator.

// name = 'Arthur' COLLATE NOCASE
Column("name").collating(.nocase) == "Arthur"

When the right operand is nil, IS NULL is used instead.

// name IS NULL
Column("name").collating(.nocase) == nil

An SQL expression that checks the boolean value of an expression.

The comparison is done with the built-in boolean evaluation of SQLite:

// validated
Column("validated") == true

// NOT validated
Column("validated") == false

An SQL expression that compares two expressions with the = SQL operator.

// 'Arthur' = name
"Arthur" == Column("name")

When the left operand is nil, IS NULL is used instead.

// name IS NULL
nil == Column("name")

An SQL expression that compares two expressions with the = SQL operator.

// 'Arthur' = name COLLATE NOCASE
"Arthur" == Column("name").collating(.nocase)

When the left operand is nil, IS NULL is used instead.

// name IS NULL
nil == Column("name").collating(.nocase)

An SQL expression that checks the boolean value of an expression.

The comparison is done with the built-in boolean evaluation of SQLite:

// validated
true == Column("validated")

// NOT validated
false == Column("validated")

An SQL expression that compares two expressions with the = SQL operator.

// email = login
Column("email") == Column("login")

An SQL expression that compares two expressions with the <> SQL operator.

// name <> 'Arthur'
Column("name") != "Arthur"

When the right operand is nil, IS NOT NULL is used instead.

// name IS NOT NULL
Column("name") != nil

An SQL expression that compares two expressions with the <> SQL operator.

// name <> 'Arthur' COLLATE NOCASE
Column("name").collating(.nocase) != "Arthur"

When the right operand is nil, IS NOT NULL is used instead.

// name IS NOT NULL
Column("name").collating(.nocase) != nil

An SQL expression that checks the boolean value of an expression.

The comparison is done with the built-in boolean evaluation of SQLite:

// NOT validated
Column("validated") != true

// validated
Column("validated") != false

An SQL expression that compares two expressions with the <> SQL operator.

// 'Arthur' <> name
"Arthur" != Column("name")

When the left operand is nil, IS NOT NULL is used instead.

// name IS NOT NULL
nil != Column("name")

An SQL expression that compares two expressions with the <> SQL operator.

// 'Arthur' <> name COLLATE NOCASE
"Arthur" != Column("name").collating(.nocase)

When the left operand is nil, IS NOT NULL is used instead.

// name IS NOT NULL
nil != Column("name").collating(.nocase)

An SQL expression that checks the boolean value of an expression.

The comparison is done with the built-in boolean evaluation of SQLite:

// NOT validated
true != Column("validated")

// validated
false != Column("validated")

An SQL expression that compares two expressions with the <> SQL operator.

// email <> login
Column("email") != Column("login")

An SQL expression that compares two expressions with the IS SQL operator.

// name IS 'Arthur'
Column("name") === "Arthur"

An SQL expression that compares two expressions with the IS SQL operator.

// name IS 'Arthur' COLLATE NOCASE
Column("name").collating(.nocase) === "Arthur"

An SQL expression that compares two expressions with the IS SQL operator.

// name IS 'Arthur'
"Arthur" === Column("name")

An SQL expression that compares two expressions with the IS SQL operator.

// name IS 'Arthur' COLLATE NOCASE
"Arthur" === Column("name").collating(.nocase)

An SQL expression that compares two expressions with the IS SQL operator.

// email IS login
Column("email") === Column("login")

An SQL expression that compares two expressions with the IS NOT SQL operator.

// name IS NOT 'Arthur'
Column("name") !== "Arthur"

An SQL expression that compares two expressions with the IS NOT SQL operator.

// name IS NOT 'Arthur' COLLATE NOCASE
Column("name").collating(.nocase) !== "Arthur"

An SQL expression that compares two expressions with the IS NOT SQL operator.

// name IS NOT 'Arthur'
"Arthur" !== Column("name")

An SQL expression that compares two expressions with the IS NOT SQL operator.

// name IS NOT 'Arthur' COLLATE NOCASE
"Arthur" !== Column("name").collating(.nocase)

An SQL expression that compares two expressions with the IS NOT SQL operator.

// email IS NOT login
Column("email") !== Column("login")

An SQL expression that compares two expressions with the < SQL operator.

// score < 18
Column("score") < 18

An SQL expression that compares two expressions with the < SQL operator.

// name < 'Arthur' COLLATE NOCASE
Column("name").collating(.nocase) < "Arthur"

An SQL expression that compares two expressions with the < SQL operator.

// 18 < score
18 < Column("score")

An SQL expression that compares two expressions with the < SQL operator.

// 'Arthur' < name COLLATE NOCASE
"Arthur" < Column("name").collating(.nocase)

An SQL expression that compares two expressions with the < SQL operator.

// width < height
Column("width") < Column("height")

An SQL expression that compares two expressions with the <= SQL operator.

// score <= 18
Column("score") <= 18

An SQL expression that compares two expressions with the <= SQL operator.

// name <= 'Arthur' COLLATE NOCASE
Column("name").collating(.nocase) <= "Arthur"

An SQL expression that compares two expressions with the <= SQL operator.

// 18 <= score
18 <= Column("score")

An SQL expression that compares two expressions with the <= SQL operator.

// 'Arthur' <= name COLLATE NOCASE
"Arthur" <= Column("name").collating(.nocase)

An SQL expression that compares two expressions with the <= SQL operator.

// width <= height
Column("width") <= Column("height")

An SQL expression that compares two expressions with the > SQL operator.

// score > 18
Column("score") > 18

An SQL expression that compares two expressions with the > SQL operator.

// name > 'Arthur' COLLATE NOCASE
Column("name").collating(.nocase) > "Arthur"

An SQL expression that compares two expressions with the > SQL operator.

// 18 > score
18 > Column("score")

An SQL expression that compares two expressions with the > SQL operator.

// 'Arthur' > name COLLATE NOCASE
"Arthur" > Column("name").collating(.nocase)

An SQL expression that compares two expressions with the > SQL operator.

// width > height
Column("width") > Column("height")

An SQL expression that compares two expressions with the >= SQL operator.

// score >= 18
Column("score") >= 18

An SQL expression that compares two expressions with the >= SQL operator.

// name >= 'Arthur' COLLATE NOCASE
Column("name").collating(.nocase) >= "Arthur"

An SQL expression that compares two expressions with the >= SQL operator.

// 18 >= score
18 >= Column("score")

An SQL expression that compares two expressions with the >= SQL operator.

// 'Arthur' >= name COLLATE NOCASE
"Arthur" >= Column("name").collating(.nocase)

An SQL expression that compares two expressions with the >= SQL operator.

// width >= height
Column("width") >= Column("height")

An SQL arithmetic multiplication.

// width * 2
Column("width") * 2

An SQL arithmetic multiplication.

// 2 * width
2 * Column("width")

An SQL arithmetic multiplication.

// width * height
Column("width") * Column("height")

An SQL arithmetic division.

// width / 2
Column("width") / 2

An SQL arithmetic division.

// 2 / width
2 / Column("width")

An SQL arithmetic division.

// width / height
Column("width") / Column("height")

An SQL arithmetic addition.

// width + 2
Column("width") + 2

An SQL arithmetic addition.

// 2 + width
2 + Column("width")

An SQL arithmetic addition.

// width + height
Column("width") + Column("height")

A negated SQL arithmetic expression.

// -width
-Column("width")

An SQL arithmetic substraction.

// width - 2
Column("width") - 2

An SQL arithmetic substraction.

// 2 - width
2 - Column("width")

An SQL arithmetic substraction.

// width - height
Column("width") - Column("height")

A logical SQL expression with the AND SQL operator.

// favorite AND 0
Column("favorite") && false

A logical SQL expression with the AND SQL operator.

// 0 AND favorite
false && Column("favorite")

A logical SQL expression with the AND SQL operator.

// email IS NOT NULL AND favorite
Column("email") != nil && Column("favorite")

A logical SQL expression with the OR SQL operator.

// favorite OR 1
Column("favorite") || true

A logical SQL expression with the OR SQL operator.

// 0 OR favorite
true || Column("favorite")

A logical SQL expression with the OR SQL operator.

// email IS NULL OR hidden
Column("email") == nil || Column("hidden")

A negated logical SQL expression with the NOT SQL operator.

// NOT hidden
!Column("hidden")

Some expressions may be negated with specific SQL operators:

// id NOT BETWEEN 1 AND 10
!((1...10).contains(Column("id")))

Return as many question marks separated with commas as the count argument.

databaseQuestionMarks(count: 3) // "?,?,?"