| Operator | Name | Description | Example |
| ----- | ----- | ----- |
| all | Logical all | TRUE if all of the values meet the condition | all([True, True, True, True] (returns true)|
| and or && | Logical and | Returns true if both statements are true | x < 2 && x > 0 |
| any | Logical any | TRUE if any of the values meet the condition | any([False, True, False, False] (returns true) |
| between | Logical between | TRUE if the operand is within the range of comparisons | between 10 and 20 |
| exists | Logical exists | TRUE if the subquery returns one or more records | |
| in | Logical in | TRUE if the operand is equal to one of a list of expressions | |
| like | Logical pattern matching |TRUE if the operand matches a pattern | |
| not or ! | Logical not | Reverse the result, returns false if the result is true | !(x > 5 && x < 10) |
| or or \|\| | Logical or | Returns true if one of the statements is true | x < 2 \|\| x > 10 |
| some | Logical some | TRUE if any of the subquery values meet the condition | |