List of Operators in delika SQL

Preview: This feature in preview state and might change or have limited support.

Unary operators

`+`

Plus.

`-`

Minus.

`NOT`

Boolean operation. Returns true if the operand is false.

Binary operators

`+`

Addition.

`-`

Subtraction.

`*`

Multiplication.

`/`

Division.

`%`

Modulo (reminder of division).

`||`

String concatenation.

`=`

Equal.

`<>`

Not equal.

`<`

Less than.

`>`

Greater than.

`<=`

Less than or equal to.

`>=`

Greater than or equal to.

`|>`

Pipe operator.

Pipe operator inserts the left hand operand as the first argument of the right hand function. e.g. x |> f() becomes f(x) and x |> f(y) |> g(z) becomes g(f(x, y), z).

`AND`

Boolean operation. Returns true if both operands are true.

`OR`

Boolean operation. Returns true if at least one of operands is true.

`IS NULL`

Null check. Returns true if the right hand operand is null.

`IS NOT NULL`

Null check. Returns false if the right hand operand is null.

`LIKE`

Comparison of string values.

Right hand operand can contain wildcard character: '%' or '_'.

`NOT LIKE`

Comparison of string values.

Right hand operand can contain wildcard character: '%' or '_'.

`IN`

Element matching in sequence.

`NOT IN`

Element matching in sequence.

Trinary operators

`BETWEEN AND`

Returns true if the first argument is between the remaing arguments (inclusive).