duckdb-jev: ask an LLM about every table row in SQL, get typed results back

dbreunig · x · 2026-09-22

A new DuckDB extension, duckdb-jev, builds on Jev (TypeSafe's model for typed answers) to let you ask a question about every row of a table in SQL and get a real SQL type back instead of text.

The idea: your data already sits in a table or Parquet file, so ask where the data is rather than pulling it out and wrapping an API in a script. Jev picks from a set you define instead of generating free text you then validate — the result is typed by construction, and not generating is what makes it cheap enough to run on every row.

Usage: CREATE SECRET (TYPE jev, APIKEY 'sk-...'); ENDPOINT and MODEL are optional.

Related event: MotherDuck's prompt_jev() Brings AI Text Classification into SQL at 50x Speed, 1% Cost(5 posts)→

Original post →

More from coding & agent

coding & agent channel →