SQL Query Generator — Ai Endpoint Template for Extractor

What It Does

Ask a question in plain English — get back a SQL query, a human-readable explanation of what it does, and the list of tables used. Generates parameterized queries with ? placeholders for safe execution.

Example

Input: "How many orders did we get last month from customers in California?"

Output:

{
  "sql": "SELECT COUNT(*) as order_count FROM orders o JOIN customers c ON o.customer_id = c.id WHERE c.state = ? AND o.created_at >= ? AND o.created_at < ?",
  "explanation": "Counts orders from the last calendar month where the customer is in California, using a join between orders and customers tables.",
  "tables_used": ["orders", "customers"]
}

When To Use This

• Internal tools — let non-technical team members query your database without writing SQL
• Analytics dashboards — add a "ask a question" feature that generates SQL from natural language
• Database exploration — quickly prototype queries during development without remembering exact column names