Natural Language to SQL Query Generator

[
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "n0",
    "timestamp": 1783210895172
  },
  {
    "data": {
      "initialData": {
        "schema": "CREATE TABLE customers (\n    customer_id INT PRIMARY KEY,\n    first_name VARCHAR(50),\n    last_name VARCHAR(50),\n    email VARCHAR(100),\n    registration_date DATE\n);\n\nCREATE TABLE orders (\n    order_id INT PRIMARY KEY,\n    customer_id INT,\n    order_date DATE,\n    total_amount DECIMAL(10, 2),\n    FOREIGN KEY (customer_id) REFERENCES customers(customer_id)\n);\n\nCREATE TABLE products (\n    product_id INT PRIMARY KEY,\n    product_name VARCHAR(100),\n    price DECIMAL(10, 2)\n);\n\nCREATE TABLE order_items (\n    order_item_id INT PRIMARY KEY,\n    order_id INT,\n    product_id INT,\n    quantity INT,\n    FOREIGN KEY (order_id) REFERENCES orders(order_id),\n    FOREIGN KEY (product_id) REFERENCES products(product_id)\n);",
        "question": "Show me the first name and email of customers who have placed more than 3 orders, along with the total number of orders they have placed."
      }
    },
    "event": "triggered",
    "nodeId": "manualTrigger",
    "timestamp": 1783210895172
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "n0",
    "timestamp": 1783210895172
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "n1",
    "timestamp": 1783210895173
  },
  {
    "data": {
      "messages": 2,
      "maxTokens": 160
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1783210895173
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1783210895173
  },
  {
    "data": {
      "model": "gpt-4o-mini-2024-07-18",
      "costUsd": 0.0010825,
      "provider": "openai",
      "latencyMs": 1046,
      "promptTokens": 217,
      "completionTokens": 54
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1783210896219
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "n1",
    "timestamp": 1783210896219
  }
]