查詢與征服：執行引導的SQL生成

Query and Conquer: Execution-Guided SQL Generation

March 31, 2025

作者: Łukasz Borchmann, Marek Wydmuch

cs.AI

摘要

我們提出了一種新穎的方法來生成複雜輸出，該方法在文本到SQL任務中顯著提高了準確性。我們的方法利用執行結果從多個候選查詢中選擇語義最一致的那個，使得更小、更具成本效益的模型能夠超越計算密集型的推理方法，如o1、o3-mini和DeepSeek R1，同時將推理成本降低多達30倍。該方法無縫集成於現有模型，為實現最先進的SQL生成提供了一條實用且可擴展的途徑。

English

We propose a novel approach for generating complex outputs that significantly improves accuracy in text-to-SQL tasks. Our method leverages execution results to select the most semantically consistent query from multiple candidates, enabling smaller, cost-effective models to surpass computationally intensive reasoning methods such as o1, o3-mini, and DeepSeek R1 while reducing inference cost by as much as 30 times. It integrates effortlessly with existing models, offering a practical and scalable pathway to state-of-the-art SQL generation.