Operators - Firebolt Documentation

Preview Snowflake operators in Snowflake compatibility mode.

Supported operators

Operator	Support	Notes
Arithmetic	Supported	`+`, `-`, `*`, `/`, `%`. See the note on integer division below.
Comparison	Supported	`=`, `!=`, `<>`, `<`, `<=`, `>`, `>=`, `BETWEEN`, `IN`, `IS NULL`.
Logical	Supported	`AND`, `OR`, `NOT`.
[`		` concatenation](https://docs.snowflake.com/en/sql-reference/operators-arithmetic)	Supported
`::` cast	Supported	Equivalent to `CAST`.
`:` path	Supported	Path access into a semi-structured column.
`[]` subscript	Supported	Array and object element access.
`LIKE`, `ILIKE`	Supported	Including `LIKE ANY`.
`RLIKE`, `REGEXP`	Supported

Limitations

Integer division differs from Snowflake and is the difference most likely to affect a real workload, because division is common and the result is plausible rather than obviously wrong:

SELECT 1/2;

Returns 0, where Snowflake returns 0.500000. Snowflake has no integer division: / always produces a NUMBER. Any migrated query that divides two integers silently returns different numbers, and there is no diagnostic. Cast one operand to make the intent explicit:

SELECT 1::FLOAT / 2;   -- 0.5 in both