Skip to main content

Conditions and operators

Conditions appear in three places: comparing the target (PREDICT COUNT(...) = 0), filtering entities (WHERE), filtering aggregated rows (inline WHERE inside an aggregation), and stating counterfactuals (ASSUMING).

Comparison operators​

= == != > >= < <=

Either side of a comparison may be a literal, a static column, an aggregation over an OVER frame, or a richer expression (arithmetic, CASE WHEN … END, COALESCE, NULLIF, ABS/LOG/EXP/LEAST/GREATEST). Column-to-column comparisons are allowed — e.g. orders.shipped_at > orders.ordered_at.

Boolean composition​

AND, OR, NOT, with parentheses.

Membership and null tests​

customers.location IN ('NY', 'CA')
customers.location NOT IN ('ALASKA', 'HAWAII')
articles.description IS NULL
articles.description IS NOT NULL

String predicates​

loan.status LIKE '%DENIED'        -- SQL % wildcards
movie.title STARTS WITH 'The'
movie.title ENDS WITH 'Returns'
movie.title CONTAINS 'Star'

Examples​

-- entity filter mixing a static attribute and a past-facing aggregation
WHERE customers.age >= 18 AND EXISTS(orders.*) OVER (90 DAYS PRECEDING)

-- predicate target: multiclass-style question on a status column
PREDICT LAST(loan.status) OVER (30 DAYS FOLLOWING) NOT LIKE '%DENIED' FOR EACH loan.id