[
  {
    "runId": "cd5a1b44-f8d0-400c-a31e-75a3464deafc",
    "step": "report",
    "inputs": {
      "schema": "users(id, name, email, created_at); orders(id, user_id, total, status, created_at)users(id, name, email, created_at); orders(id, user_id, total, status, created_at)",
      "question": "Show me total revenue per user with more than 3 paid orders in 2025"
    },
    "artifacts": {
      "ruleHits": {
        "rulesetVersion": "sql-safety@2026-07-19.3",
        "hits": []
      },
      "modelText": "-- Dialect: PostgreSQL\n-- Schema: users(id, name, email, created_at); orders(id, user_id, total, status, created_at)users(id, name, email, created_at); orders(id, user_id, total, status, created_at)\n\nSELECT u.name, SUM(o.total) AS revenue\nFROM users u\nJOIN orders o ON o.user_id = u.id\nWHERE o.status = 'paid' AND o.created_at >= '2025-01-01'\nGROUP BY u.name\nHAVING COUNT(o.id) > 3\nORDER BY revenue DESC;\n\n-- Explanation: joins users and orders, keeps paid 2025 orders, groups by user,\n-- keeps only those with >3 orders, ranks by revenue.\n-- Safety: parameterized filters, has WHERE, no DROP/DELETE. (Demo. Add OPENAI_API_KEY for a query from your real question.)"
    },
    "status": "done",
    "pipelineId": "sql-fix-v1",
    "createdAt": "2026-08-16T16:15:52.575Z",
    "updatedAt": "2026-08-16T16:15:52.575Z",
    "rulesetVersion": "sql-safety@2026-07-19.3"
  },
  {
    "runId": "57959be5-6e3e-48ed-b1fd-786449f02f92",
    "step": "report",
    "inputs": {
      "schema": "users(id, name, email, created_at); orders(id, user_id, total, status, created_at)",
      "question": "Show me total revenue per user who placed more than 3 paid orders in 2025, sorted by revenue descending"
    },
    "artifacts": {
      "ruleHits": {
        "rulesetVersion": "sql-safety@2026-07-19.3",
        "hits": []
      },
      "modelText": "-- Dialect: PostgreSQL\n-- Schema: users(id, name, email, created_at); orders(id, user_id, total, status, created_at)\n\nSELECT u.name, SUM(o.total) AS revenue\nFROM users u\nJOIN orders o ON o.user_id = u.id\nWHERE o.status = 'paid' AND o.created_at >= '2025-01-01'\nGROUP BY u.name\nHAVING COUNT(o.id) > 3\nORDER BY revenue DESC;\n\n-- Explanation: joins users and orders, keeps paid 2025 orders, groups by user,\n-- keeps only those with >3 orders, ranks by revenue.\n-- Safety: parameterized filters, has WHERE, no DROP/DELETE. (Demo. Add OPENAI_API_KEY for a query from your real question.)"
    },
    "status": "done",
    "pipelineId": "sql-fix-v1",
    "createdAt": "2026-08-16T16:14:01.640Z",
    "updatedAt": "2026-08-16T16:14:01.640Z",
    "rulesetVersion": "sql-safety@2026-07-19.3"
  },
  {
    "runId": "2ba1dbc7-45e6-48a8-be46-0867a3776109",
    "step": "report",
    "inputs": {
      "question": "total revenue per user who placed more than 3 paid orders in 2025"
    },
    "artifacts": {
      "ruleHits": {
        "rulesetVersion": "sql-safety@2026-07-19.3",
        "hits": []
      },
      "modelText": "-- Dialect: PostgreSQL\n-- Schema: your tables\n\nSELECT u.name, SUM(o.total) AS revenue\nFROM users u\nJOIN orders o ON o.user_id = u.id\nWHERE o.status = 'paid' AND o.created_at >= '2025-01-01'\nGROUP BY u.name\nHAVING COUNT(o.id) > 3\nORDER BY revenue DESC;\n\n-- Explanation: joins users and orders, keeps paid 2025 orders, groups by user,\n-- keeps only those with >3 orders, ranks by revenue.\n-- Safety: parameterized filters, has WHERE, no DROP/DELETE. (Demo. Add OPENAI_API_KEY for a query from your real question.)"
    },
    "status": "done",
    "pipelineId": "sql-fix-v1",
    "createdAt": "2026-08-16T16:23:28.744Z",
    "updatedAt": "2026-08-16T16:23:28.744Z",
    "rulesetVersion": "sql-safety@2026-07-19.3"
  }
]