SQL Query Generator from Natural Language

{
  "dialect": "postgresql",
  "table_schema": "users(id, name, email, created_at), purchases(id, user_id, purchase_date, amount)",
  "natural_language_query": "Find all users who have made at least 2 purchases in the last 90 days"
}

{
  "sql": "SELECT u.id, u.name, u.email FROM users u INNER JOIN purchases p ON u.id = p.user_id WHERE p.purchase_date >= NOW() - INTERVAL '90 days' GROUP BY u.id, u.name, u.email HAVING COUNT(p.id) >= 2",
  "_meta": {
    "payment": {
      "method": "x402",
      "price_usd": 0.054000000000000006,
      "settlement_id": "0xe39fa3c65478682bc689db7b1e8244e3839b4c9c0695b797e73d2cce7b0aa44c"
    },
    "capability": "sql-generate",
    "latency_ms": 1467,
    "provenance": {
      "source": "claude-haiku",
      "fetched_at": "2026-06-13T04:25:05.951Z"
    }
  },
  "dialect": "postgresql",
  "joins_used": [
    "INNER JOIN purchases p ON u.id = p.user_id"
  ],
  "explanation": "This query finds all users who have made at least 2 purchases within the last 90 days. It joins the users table with the purchases table, filters purchases from the last 90 days, groups by user, and returns only those users with 2 or more purchases in that period.",
  "tables_referenced": [
    "users",
    "purchases"
  ],
  "estimated_complexity": "simple"
}