LLM-backed extraction (escape hatch for EXTRACTS)
Per-row — runs once for each row.
{{ text }} EXTRACTS_LLM '{{ what }}'semantic_extract_llm({{ text }}, '{{ what }}')| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| what | VARCHAR | — |
LLM escape hatch: price extracted
SELECT
semantic_extract_llm ('The price is $49.99 per unit', 'price')LLM escape hatch: email extracted
SELECT
semantic_extract_llm ('Contact John Smith at john@company.com', 'email')Crawl a website and extract structured data from each page (via Firecrawl)
Extract specific information from unstructured text (zero-shot NER)
Extract structured fields from text per a user-supplied schema
Merge multiple timelines into unified chronological sequence
Extract information from text using natural-language instructions
Parse, validate, or transform patterned strings using plain-English instructions
LLM-backed extraction (escape hatch for EXTRACTS)
Per-row — runs once for each row.
{{ text }} EXTRACTS_LLM '{{ what }}'semantic_extract_llm({{ text }}, '{{ what }}')| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| what | VARCHAR | — |
LLM escape hatch: price extracted
SELECT
semantic_extract_llm ('The price is $49.99 per unit', 'price')LLM escape hatch: email extracted
SELECT
semantic_extract_llm ('Contact John Smith at john@company.com', 'email')Crawl a website and extract structured data from each page (via Firecrawl)
Extract specific information from unstructured text (zero-shot NER)
Extract structured fields from text per a user-supplied schema
Merge multiple timelines into unified chronological sequence
Extract information from text using natural-language instructions
Parse, validate, or transform patterned strings using plain-English instructions