{
    "action": "tool_call",
    "reasoning": "I need to get the distribution of serious adverse events (AESER) by body system (AEBODSYS), which are the most critical metric and category for clinical trial safety decisions. I'll also include severity (AESEV) and outcomes (AEOUT) to provide complete safety context. This single query will give me counts and percentages across the key safety dimensions.",
    "tool": "query_sql",
    "args": {
        "sql": "SELECT AEBODSYS AS body_system, COUNT(*) AS total_events, SUM(CASE WHEN AESER = 'Y' THEN 1 ELSE 0 END) AS serious_events, ROUND(100.0 * SUM(CASE WHEN AESER = 'Y' THEN 1 ELSE 0 END) / COUNT(*), 1) AS serious_pct, SUM(CASE WHEN AESEV = 'SEVERE' THEN 1 ELSE 0 END) AS severe_events, SUM(CASE WHEN AESEV = 'MODERATE' THEN 1 ELSE 0 END) AS moderate_events, SUM(CASE WHEN AESEV = 'MILD' THEN 1 ELSE 0 END) AS mild_events, SUM(CASE WHEN AEOUT = 'FATAL' THEN 1 ELSE 0 END) AS fatal_outcomes FROM raw.ae GROUP BY AEBODSYS ORDER BY serious_events DESC, total_events DESC",
        "purpose": "Get the breakdown of serious adverse events (the most critical safety metric) by body system (the most important category for safety stratification), including severity and fatal outcomes",
        "source": "raw"
    }
}