surfaceclassificationmatch_template
Classificationscalar · returns boolean

MATCH_TEMPLATE

Evaluate whether a plain-English statement is true or false

Per-row — runs once for each row.

classificationllmtext

Arguments

nametypedescription
statementVARCHAR

About

Evaluate whether a plain-English statement is true or false and return a boolean. Handy as a WHERE predicate when the condition is natural language ("does this review mention shipping?", "is this address in California?") rather than a SQL expression. Smaller and more focused than ASK for yes/no questions — because the prompt is templated to force a strict true/false response, the output is reliably parseable with no post-processing. For richer evaluation (extracting an answer, classifying into more than two buckets, or returning free-form text), reach for ASK instead.

Examples

True statement returns true

SELECT
  semantic_match_template ('The Earth orbits the Sun')

Nearby rabbit holes

same domain
Climb back to The Looking Glass