Validate a value against a plain-English rule (more flexible sibling of VALID)
Per-row — runs once for each row.
VALIDATE({{ value }}, '{{ rule }}'){{ value }} VALIDATES '{{ rule }}'| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| rule | VARCHAR | Validation rule in natural language |
Text with price passes rule
SELECT
validate ('This product costs $29.99', 'contains pricing')Text without date fails rule
SELECT
validate ('Hello world', 'contains a date')Remove or mask personally identifiable information from text
Type-cast messy real-world values that trip up standard CAST
Return the canonical/official form of a value (auto-detects entity type)
Extracts 4-digit year from messy text, returns -1 if undetermined
LLM-backed year extraction (escape hatch for CLEAN_YEAR)
Pick the best non-null value from a group (quality-aware COALESCE)
Validate a value against a plain-English rule (more flexible sibling of VALID)
Per-row — runs once for each row.
VALIDATE({{ value }}, '{{ rule }}'){{ value }} VALIDATES '{{ rule }}'| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| rule | VARCHAR | Validation rule in natural language |
Text with price passes rule
SELECT
validate ('This product costs $29.99', 'contains pricing')Text without date fails rule
SELECT
validate ('Hello world', 'contains a date')Remove or mask personally identifiable information from text
Type-cast messy real-world values that trip up standard CAST
Return the canonical/official form of a value (auto-detects entity type)
Extracts 4-digit year from messy text, returns -1 if undetermined
LLM-backed year extraction (escape hatch for CLEAN_YEAR)
Pick the best non-null value from a group (quality-aware COALESCE)