Relational Operators in QBE

Relational operators in QBE are comparison operators that allows you to evaluate or check the relationship between two values, returning a Boolean result which allows filtering, searching or sorting the data in your queries.

GraphQL QBE Relational Operator Equivalent SQL Operator
_eq and _ne Equivalent to '=' and '!='.
_lt and _lte Equivalent to '<' and '<='.
_gt and _gte Equivalent to '>' and '>='.
_like Equivalent to 'like'.
_is_null Equivalent to 'where <field> is null'. Example - Office: {_is_null: TRUE}
_in, _nin, and _between Equivalent to IN, NOT IN, and BETWEEN