Track-SQL: Enhancing Generative Language Models with Dual-Extractive Modules for Schema and Context Tracking in Multi-turn Text-to-SQL
This work addresses the challenge that generative language models struggle to effectively model dynamically evolving database schemas and contextual dependencies in multi-turn Text-to-SQL tasks. To this end, the authors propose a dual extraction-augmented architecture comprising a semantics-enhanced schema extractor and a schema-aware context extractor, which jointly track schema evolution and contextual information across dialogue turns with high precision. These components are integrated with a generative language model and co-optimized for SQL generation. The proposed approach achieves state-of-the-art performance, yielding absolute improvements of 7.1% and 9.55% in execution accuracy on the SparC and CoSQL benchmarks, respectively.