jevbooks

← All projects

jevql

kylemclaren/jevql · Homepage

Semantic SQL for vanilla Postgres, powered by Jev

Data Labeling & Curation47%Runner-up: Scoring & Ranking

What it is

A psql-shaped CLI and Go/TypeScript/Python SDKs that run plain SQL on vanilla Postgres (no extension), then ask Jev questions about each surviving row so clients can filter, sort and group semantically.

How it uses Jev

jev(), jev_prob(), jev_choice(), jev_score(), jev_confidence() and jev_eval() take a FROM alias (or column list) and a question; the CLI packs that relation's columns into a JSON row object, sends it to TypeSafe's System One model, and attaches the returned boolean, probability, choice or score in process before filtering, grouping, sorting and limiting.

Primitives:choicescorenoul

Technique worth stealing

Strip jev predicates, GROUP BY and jev-dependent ORDER BY/LIMIT from the SQL, send the rest to Postgres, then judge only the surviving rows and project the answers back in process.

Try it

brew install kylemclaren/tap/jevql, export TYPESAFE_API_KEY and DATABASE_URL, then run jevql -c "SELECT * FROM people WHERE jev(people, 'could work from home')".

View on GitHub

judged by Jevjev-1.13.0

Evidence

Each line is one question put to Jev about the README. ≥ 0.60 reads as yes, ≤ 0.40 as no; in between Jev is not making a call.

  • Jev-centricyes0.90
  • Shows a System One patternyes0.61
  • Handles uncertaintyno0.05
  • Measuredno0.05
  • Runnableyes0.98
  • Worth recommendingunclear0.55
  • Model replicano0.04
  • Problem scopescore on a 0–2 scale0.98
  • About Jevyes0.98

Signals by Jev jev-1.13.0, card written by DeepSeek V4.1 Flash from the README on 20 Sept 2026.