duckdb-jev

What it is

A DuckDB extension that lets you ask a Jev question about every row of a table or Parquet file in SQL, returning real SQL types instead of text.

How it uses Jev

Each function takes a row's text plus a constant criteria literal that defines both the permitted answers and the column type. Jev picks from that set, and the typed result is used directly as an ENUM, DOUBLE, or STRUCT field in SQL.

Primitives:choicescorenoul

Technique worth stealing

Declare the answer set as a constant criteria literal so the result is typed by construction, not by validation.

Try it

CREATE SECRET (TYPE jev, API_KEY 'sk-...'); then call jev_choice, jev_score, jev_noul, or jev_ask.

View on GitHub