Towards Automating Domain-Specific Data Generation for Text-to-SQL: A Comprehensive Approach