Operators

All dialects support the following standard operators:

• Arithmetic: +, -, *, /
• Comparison: =, >, >=, <, <=, <>, !=
• Logical: AND, OR, NOT, IS, IS NOT

The standard also defines operators that aren't supported a lot in actual implementations:

• :: static method invocation
• -> attribute or method reference
• || string concatenation
• .. embedded Ada and Pascal syntax

Below only additional non-standard operators are listed (the uncommon ones (::, ->, ||, ..) are assumed to be unsupported unless mentioned otherwise):

BigQuery:

• Bitwise: &, |, ^, ~, <<, >>
• String/Array concatenation: ||

DB2:

• Arithmetic: **
• Comparison: ¬=, ¬>, !>, ¬<, !<
• String concatenation: CONCAT, ||

Hive:

• Arithmetic: %, DIV
• Bitwise: ~, ^, |, &
• Comparison: ==, <=> (NULL-safe equal operator)
• Logical: !
• String concatenation: ||

MariaDB:

• Arithmetic: %, MOD, DIV
• Assignment: :=
• Bitwise: &, |, ^, ~, >>, <<
• Comparison: <=> (NULL-safe equal operator)
• Logical: &&, ||, XOR, !

MySQL:

• Arithmetic: %, MOD, DIV
• Assignment: :=
• Bitwise: &, |, ^, ~, >>, <<
• Comparison: <=> (NULL-safe equal operator)
• JSON: ->, ->>
• Logical: &&, ||, XOR, !

N1QL:

• Arithmetic: %
• Comparison: ==
• String concatenation: ||

PL/SQL:³

• Assignment: :=
• Comparison: ^=
• FOR loop range: ..
• Named arguments: =>
• String concatenation: ||

PostgreSQL:

TODO

Redshift:

• Arithmetic: ^, %, @ (absolute value), |/ (square root) ||/ cube root
• Bitwise: &, |, #, ~, <<, >>
• String concatenation: ||

SingleStoreDB:

• Assignment:² :=
• Bitwise: &, |, ^, ~, >>, <<
• Comparison: <=> (NULL-safe equal operator)
• Logical:¹ &&, ||

Spark:

Same as Hive.

SQLite:

• Arithmetic: %
• Bitwise: ~, &, |, <<, >>
• Comparison: ==
• JSON: ->, ->>
• String concatenation: ||

Transact-SQL:

• Arithmetic: %
• Bitwise: &, |, ^, ~
• Comparison: !<, !>
• Compound: +=, -=, *=, /=, %=, &=, |=, ^=
• Scope resolution: ::

Trino:

• Arithmetic: %
• Lambda expression: ->
• String concatenation: ||

Notes:

1. Tested SingleStoreDB boolean operators manually. Found no docs for these.
2. SingleStoreDB only clearly documents the use of = operator for assignment, but testing shows that := works as well (the docs also contain a lonely example that uses the := syntax).
3. Tested on Oracle Live SQL playground the following operators: >>, <<, **, ~=. All of them produced an error.