SQL-of-Thought: Multi-agentic Text-to-SQL with Guided Error Correction