沙丘社区
论文

GATE：利用查询执行反馈补充Text-to-SQL的语义定义

Bootstrapping Semantic Layer from Execution for Text-to-SQL

Youngwon Lee, Jaejin Kim, Seung-won Hwang
上下文与知识上下文工程知识库AI语义层

摘要

GATE暂不确定缺少业务含义的SQL部分，先执行已确定部分，再依据查询观察选择解释并保存可复用记录。实验比较其在真实与受控数据集中的查询表现。 语义定义不完整时，执行结果可以帮助补充字段与业务表达之间的映射；仍需检验观察是否支持该解释。

GATE：利用查询执行反馈补充Text-to-SQL的语义定义原论文配图
Figure 1: Keeping grounding hypotheses open until execution supports one. The query requires runner_up_gap , but the part producing it remains open while sprint_rows is already grounded and executable. Rather than writing one grounding hypothesis into SQL upfront, GATE (1) keeps grounding hypotheses open and (2) executes over sprint_rows . (3) The observation supports the grounding that treats rank-2 final_time as the runner-up’s gap, yielding a memory entry for runner_up_gaps that can later be reused.