LLM-backed 0.0-1.0 relevance score (escape hatch for ABOUT/RELEVANCE TO)
Per-row — runs once for each row.
{{ text }} ABOUT_LLM {{ criterion }}{{ text }} RELEVANCE_LLM TO {{ criterion }}semantic_score_llm({{ text }}, {{ criterion }})| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| criterion | VARCHAR | — |
LLM escape hatch: high quality score
SELECT
semantic_score_llm (
'The food was excellent, service was great',
'quality'
)LLM escape hatch: unrelated text low score
SELECT
semantic_score_llm (
'The meeting starts at noon in conference room B',
'quality'
)Returns 0.0-1.0 relevance score for text vs criterion (cross-encoder)
Pick the single best value from a group by a plain-English quality criterion
Find unusual or atypical items via embeddings (+ optional criteria)
LLM-backed outlier detection (escape hatch for OUTLIERS)
PageRank centrality on an ad-hoc edge list (NetworkX)
Rank a group of items by a subjective multi-factor criterion
LLM-backed 0.0-1.0 relevance score (escape hatch for ABOUT/RELEVANCE TO)
Per-row — runs once for each row.
{{ text }} ABOUT_LLM {{ criterion }}{{ text }} RELEVANCE_LLM TO {{ criterion }}semantic_score_llm({{ text }}, {{ criterion }})| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| criterion | VARCHAR | — |
LLM escape hatch: high quality score
SELECT
semantic_score_llm (
'The food was excellent, service was great',
'quality'
)LLM escape hatch: unrelated text low score
SELECT
semantic_score_llm (
'The meeting starts at noon in conference room B',
'quality'
)Returns 0.0-1.0 relevance score for text vs criterion (cross-encoder)
Pick the single best value from a group by a plain-English quality criterion
Find unusual or atypical items via embeddings (+ optional criteria)
LLM-backed outlier detection (escape hatch for OUTLIERS)
PageRank centrality on an ad-hoc edge list (NetworkX)
Rank a group of items by a subjective multi-factor criterion