Agents query databases differently from humans or BI tools: they engage in 'agentic speculation'—generating a diverse stream of heterogeneous queries, including schema introspection, column exploration, partial queries, and full queries. Each user request may trigger thousands of SQL queries. Experiments on text-to-SQL benchmarks show that when multiple agents attempt the same task, only 10-20% of subplans are unique, meaning 80-90% of subqueries are redundant. While redundancy helps improve task success rates, it is wasteful from the data system's perspective.
Data systems can reuse results of overlapping subplans, leveraging existing techniques like multi-query optimization and shared scans; they can also return approximate answers to help agents move forward quickly. Additionally, data systems can support batch queries and higher-level primitives (e.g., DBT-style Jinja macros) rather than requiring agents to list SQL one by one. More importantly, data systems can proactively guide agents: providing latency estimates, precomputed views, or results from related queries, because agents can accept arbitrary text feedback without requiring strict SQL results.