Query everything.
Move nothing.

typed intent

{
  "measure": "sum(orders.amount)",
  "dimension": "region",
  "concepts": [
    "Revenue",
    "Region",
    "Customer"
  ],
  "filters": [
    "status = 'fulfilled'",
    "order_date in Q2 2026"
  ],
  "grain": "region",
  "limit": 500
}

validation

• ✓Read-only statement — no DDL/DML detected
• ✓All referenced columns exist in the schema graph
• ✓Join path uses an approved relationship
• ✓Estimated cost within source policy budget

generated sql (executed in source)

SELECT c.region,
       SUM(o.amount) AS revenue
FROM customers c
JOIN orders o ON c.id = o.customer_id   -- approved relationship
WHERE o.status = 'fulfilled'
  AND o.order_date >= '2026-04-01'
  AND o.order_date <  '2026-07-01'
GROUP BY c.region
ORDER BY revenue DESC;

agent trace

1. Intent ParserTokenised request: "Show me revenue by region for Q2."
2. Ontology AgentResolved “revenue” → approved measure Revenue; “by region” → dimension Region
3. Schema AgentSelected customers.region, orders.amount, orders.order_date
4. Mapping AgentJoin path orders.customer_id → customers.id (approved FOREIGN KEY)
5. Validation AgentValidated projection, join and Q2 date predicate
6. Visualization AgentCategorical dimension × monetary measure → bar chart