Exploring Advanced Reasoning Methods for Domain-Specific, Complex Text-to-SQL

A Comparative Analysis of Direct, CoT, and Agentic Methods Using Gemini 2.5 and GPT-5 Mini on Extremely Hard Queries