LLM-backed boolean match (escape hatch for MEANS when encoder-based matching is insufficient)
Per-row — runs once for each row.
{{ text }} MEANS_LLM {{ criterion }}{{ text }} MATCHES_LLM {{ criterion }}semantic_matches_llm({{ text }}, {{ criterion }})| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| criterion | VARCHAR | — |
LLM escape hatch: topical match
SELECT
semantic_matches_llm ('stock prices fell today', 'financial news')LLM escape hatch: unrelated topics
SELECT
semantic_matches_llm ('basketball game results', 'cooking recipes')How strongly text supports a specific message or stance (0.0-1.0)
Check if an image semantically matches a text query (cross-modal)
Cross-modal cosine similarity between an image and a text query
Fuzzy cross-match two string arrays via bge-m3 embeddings
Checks whether two values match under a relationship
Returns TRUE if text semantically matches the criterion (cross-encoder)
LLM-backed boolean match (escape hatch for MEANS when encoder-based matching is insufficient)
Per-row — runs once for each row.
{{ text }} MEANS_LLM {{ criterion }}{{ text }} MATCHES_LLM {{ criterion }}semantic_matches_llm({{ text }}, {{ criterion }})| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| criterion | VARCHAR | — |
LLM escape hatch: topical match
SELECT
semantic_matches_llm ('stock prices fell today', 'financial news')LLM escape hatch: unrelated topics
SELECT
semantic_matches_llm ('basketball game results', 'cooking recipes')How strongly text supports a specific message or stance (0.0-1.0)
Check if an image semantically matches a text query (cross-modal)
Cross-modal cosine similarity between an image and a text query
Fuzzy cross-match two string arrays via bge-m3 embeddings
Checks whether two values match under a relationship
Returns TRUE if text semantically matches the criterion (cross-encoder)