ZAS-SQL: Distilling Rules from Failures for Zero-Shot Text-to-SQL
Researchers have developed ZAS-SQL, a novel zero-shot framework for translating natural language into SQL queries. This method identifies and distills recurring patterns from model failures to create generation rules, significantly improving accuracy without requiring example data. The framework incorporates knowledge-augmented schema representation, rule-driven structured reasoning, and execution-guided early stopping to enhance performance. ZAS-SQL achieves new state-of-the-art results on the Spider benchmark, outperforming even few-shot and fine-tuned GPT-4 models, and demonstrates strong generalization across domains and model sizes. AI
IMPACT Establishes a new zero-shot SOTA for Text-to-SQL, potentially reducing the need for extensive few-shot examples and improving cross-domain generalization.