{
    "action": "tool_call",
    "reasoning": "Date is VARCHAR with some dirty values; extract d/m/y via regex and aggregate monthly deal count and disclosed amount to see whether funding is accelerating or slowing.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH p AS (SELECT try_cast(regexp_extract(\"Date dd/mm/yyyy\", '(\\d{1,2})/(\\d{1,2})/(\\d{4})', 3) AS INT) AS y, try_cast(regexp_extract(\"Date dd/mm/yyyy\", '(\\d{1,2})/(\\d{1,2})/(\\d{4})', 2) AS INT) AS m, try_cast(replace(\"Amount in USD\", ',', '') AS DOUBLE) AS amt FROM raw.startup_funding) SELECT make_date(y, m, 1) AS month, COUNT(*) AS deals, COUNT(amt) AS deals_with_amount, SUM(amt) AS total_usd, MEDIAN(amt) AS median_usd FROM p WHERE y IS NOT NULL AND m BETWEEN 1 AND 12 GROUP BY 1 ORDER BY 1",
        "purpose": "Monthly deal count and disclosed funding amount over time",
        "source": "raw"
    }
}