jevbooks

← All projects

Deterministic-Text-to-SQL

snaga/Deterministic-Text-to-SQL · Homepage

Deterministic Text-to-SQL via Jev and sqlglot AST builder

Other0.41Runner-up: Classification & Routing
Automated README summary

Automatically summarized from the README on 25 Oct 2026; not a run by jevbooks. Run instructions and author-reported outcomes still need verification.

What it is

A Python Text-to-SQL engine and CLI that turns natural-language questions into deterministic SQL using an Apache Ossie semantic model, for developers and AI agents needing reliable, fast query synthesis.

How it uses Jev

Jev makes typed decisions over the semantic model and parsed question state to resolve intent (tables, dimensions, metrics, filters) and detect ambiguity; results drive sqlglot AST construction, with HITL prompts when clarification is needed.

Primitives:choicescore

Technique worth stealing

Pair a System 1 classifier with a typed SQL AST builder so intent decisions map deterministically to SQL.

Try it

pip install -e . then run deterministic-text-to-sql query "..." --schema examples/tpch/tpch_semantic_model.yaml

View on GitHub

Start using Jev: API key and your first request →

Model judgments from README excerpts

Project signals use repository metadata, an existing summary and the first 700 README characters, not the full project. “Not found” means not detected in that material; it does not establish absence. These are the original judgments with recorded models and dates, not source audits or run results.

Models & evaluation dates

Inclusion gate
jev-1.14.0
Project signals
jev-1.14.0
Category
jev-1.14.0
Pattern tags
jev-1.14.0

Evidence

These signals use repository metadata, an existing summary and at most 700 cleaned README characters. ≥ 0.60 means reported in that excerpt; ≤ 0.40 means not found there. The middle band is inconclusive. None is a source-code audit or a test result. The runnable-tool question excludes research experiments; the recommendation question asks for a learning shortlist, not a quality verdict.

  • Jev is core to the projectFound in material0.82
  • Shows a System One patternnot found in the excerpt0.22
  • Describes handling uncertaintynot found in the excerpt0.04
  • Reports measured numbersnot found in the excerpt0.30
  • Is a runnable toolFound in material0.97
  • Top-10 learning shortlist signalnot found in the excerpt0.13
  • Is a replica of the modelnot found in the excerpt0.10
  • Solves a common problem (0–2)score on a 0–2 scale1.25 / 2
  • About JevFound in material0.95
Signals
Jev is core to the project0.82Shows a System One pattern0.22Describes handling uncertainty0.04Reports measured numbers0.30Is a runnable tool0.97Top-10 learning shortlist signal0.13Is a replica of the model0.1000.51Solves a common problem (0–2)1.25 / 2012

no-judgment band (0.40–0.60)

Design patterns
Funnel0.25Menu0.2100.51

no-judgment band (0.40–0.60)

The Jev model and date for each judgment stage are listed above. Card written by DeepSeek V4.1 Flash from the README on 25 Oct 2026.