From Queries to Insights: Agentic LLM Pipelines for Spatio-Temporal Text-to-SQL