The Agentic SQL Architect: Engineering Databases That Reason