论文精选73°

SQLMorph:文本转SQL评估新框架

SQLMorph: Query Mutation and Fine-Grained Metrics for Text-to-SQL Evaluation

精选理由

SQLMorph提供文本转SQL系统评估新方法,通过查询变异和细粒度指标,帮助开发者更准确评估系统性能并发现潜在问题。

SQLMorph通过查询变异技术解决文本转SQL系统评估难题。该框架引入连接查询扩展(JQE)和文本查询增强(TQA)两种技术,可自动生成评估集。JQE通过有效连接增加结构复杂度,TQA生成受控自然语言扰动。实验显示,JQE增加查询覆盖率并揭示准确率随连接数增加而下降;TQA显示缩写导致的语言脆弱性可使准确率降低17%。SQLMorph还引入执行精确率(EXP)和执行召回率(EXR)等细粒度指标,弥补传统二元评估局限。

原文 · arXiv cs.AI

SQLMorph: Query Mutation and Fine-Grained Metrics for Text-to-SQL Evaluation

Text-to-SQL systems translate natural language queries into executable SQL, democratizing access to structured data. Despite recent advances driven by large language models (LLMs), evaluation remains a major bottleneck: public benchmarks fail to capture the complexity of enterprise schema, while building private evaluation sets is costly and nondeterministic, making evaluation results difficult to reproduce. To address this issue, we present SQLMorph, a framework for Text-to-SQL evaluation via query mutation. SQLMorph introduces two techniques to automatically generate and expand evaluation sets: Join Query Expansion (JQE), which systematically increases structural complexity through valid join additions, and Textual Query Augmentation (TQA), which generates controlled natural language perturbations to assess robustness to linguistic variation. JQE and TQA create targeted choke points to challenge specific system components. When applied to state-of-the-art systems, JQE increases query coverage and reveals accuracy degradation as the number of joins grows. Meanwhile, TQA shows that linguistic brittleness induced by heavy abbreviation can reduce accuracy by up to 17%. Beyond evaluation sets, SQLMorph introduces a family of execution-level metrics that address the limitations of current binary measures, such as Execution Accuracy. We define Execution Precision (EXP) and Execution Recall (EXR) to quantify the fraction of correct and recovered results, respectively, and combine them via F1 for unified scoring. Our experiments show that these relaxed metrics enable fine-grained analysis of over- and under-prediction, revealing differences across systems that binary metrics obscure. Together, SQLMorph's query mutation and fine-grained metrics support debugging and better align Text-to-SQL evaluation practices with real-world deployments.