Expressions & Operators
Comparison Operators
Section titled “Comparison Operators”| BQL | SQL | Description |
|---|---|---|
= | = | Equal |
!= | != | Not equal |
> | > | Greater than |
>= | >= | Greater than or equal |
< | < | Less than |
<= | <= | Less than or equal |
Examples
Section titled “Examples”-- Equalfilter id = 1filter status = "active"
-- Not equalfilter status != "deleted"
-- Greater thanfilter age > 18
-- Greater than or equalfilter score >= 100
-- Less thanfilter price < 50
-- Less than or equalfilter quantity <= 10Literals
Section titled “Literals”Integers
Section titled “Integers”filter count = 42filter price = 0filter offset = -10Booleans
Section titled “Booleans”filter active = truefilter deleted = falseStrings
Section titled “Strings”filter name = "Alice"filter status = "pending"Identifiers
Section titled “Identifiers”Identifiers (table and column names) must:
- Start with a letter or underscore
- Contain only letters, numbers, and underscores
-- Valid identifiersUseruser_namecreated_at_privateTable123
-- Invalid identifiers123table -- starts with numberuser-name -- contains hyphenmy.field -- contains dotFuture Features
Section titled “Future Features”The following operators are planned but not yet implemented:
Logical Operators
Section titled “Logical Operators”-- Coming soonfilter age > 18 and active = truefilter premium = true or trial = truefilter not deletedIN Operator
Section titled “IN Operator”-- Coming soonfilter status in ("active", "pending")LIKE / Pattern Matching
Section titled “LIKE / Pattern Matching”-- Coming soonfilter name like "A%"