SQL from Question Lab

cd apps/experiments/sql-from-question-lab
pnpm install
pnpm dev

SQL from Question Lab takes DDL + an English question and returns parameterized Postgres SQL plus an explanation via generateObject. Optional Neon execution (run: true) only proceeds when DATABASE_URL is set, demo tables products / orders exist, and the SQL is a single safe SELECT without bind params. Otherwise the lab stays explain-only. No AI keys - 503.

FeaturesCopy Anchor Link

• DDL + question – sample e-commerce schema included.
• Parameterized SQL – $1 style with param descriptions.
• Unsafe flag – model marks writes / multi-statements.
• Optional Neon run – off by default; gated in the Route Handler.
• Honest unavailable state.

Server ReferenceCopy Anchor Link

POST /api/sqlCopy Anchor Link

{ "ddl": "...", "question": "...", "run": false }

Success (200)Copy Anchor Link

{
  "sql": "SELECT p.name, SUM(o.qty) AS total_qty ...",
  "explanation": "Aggregates order quantities for active products.",
  "params": [],
  "unsafe": false,
  "run": {
    "attempted": false,
    "ok": false,
    "detail": "Explain-only (default)..."
  },
  "provider": "ai-gateway"
}

Implementation DetailsCopy Anchor Link

Use CasesCopy Anchor Link

• Teach text-to-SQL with honest execution gates.
• Draft analytics queries from DDL.
• Pair with Neon Postgres Lab for real tables.

LimitationsCopy Anchor Link

• Parameterized free-form SQL is explain-only (no bind API).
• Demo tables must already exist for run mode.
• No auth / rate limits.

Use in your projectCopy Anchor Link

Reuse the explain-first pattern; add a proper query builder before binding user-facing parameters.

DeploymentCopy Anchor Link

Deploy on Vercel

Local DevelopmentCopy Anchor Link

cd apps/experiments/sql-from-question-lab
pnpm install
pnpm dev

ConfigurationCopy Anchor Link

Vercel / Next.js Features UsedCopy Anchor Link

• AI SDK generateObject
• Vercel AI Gateway
• Neon serverless driver
• Route Handlers
• Zod

Next StepsCopy Anchor Link