Text-to-SQL as Dual-State Reasoning: Integrating Adaptive Context and Progressive Generation