Introduction
Filter, rank, and classify Postgres rows in plain language.
Write the condition the way you would say it. Postgres does the rest.
sql
SELECT * FROM reviews
WHERE jev(reviews, 'the customer sounds frustrated');jev() is an ordinary SQL function. It judges each row with TypeSafe's Jev and returns a boolean, a probability, a rubric score, or a class. No index, no embeddings, no vector column.
It composes with the rest of the query: AND age > 40, joins, GROUP BY, ORDER BY jev_prob(...).
sql
SELECT subject, jev_prob(tickets, 'the customer is angry') AS p
FROM tickets
ORDER BY p DESC
LIMIT 20;Every row still goes to the API. That is by design. See How it works if you need the batching and cache, and Where it runs before you install.
Next: Installation or Quick start.
