paper-with-me

홈 › Papers

The Death of Schema Linking? Text-to-SQL in the Age of Well-Reasoned Language Models

2024-08-14 · Karime Maamari, Fadhil Abubaker, Daniel Jaroslawicz, Amine Mhedhbi

Schema linking is a crucial step in Text-to-SQL pipelines. Its goal is to retrieve the relevant tables and columns of a target database for a user's query while disregarding irrelevant ones. However, imperfect schema linking can often exclude required columns needed for accurate query generation. In this work, we revisit schema linking when using the latest generation of large language models (LLMs). We find empirically that newer models are adept at utilizing relevant schema elements during generation even in the presence of large numbers of irrelevant ones. As such, our Text-to-SQL pipeline entirely forgoes schema linking in cases where the schema fits within the model's context window in order to minimize issues due to filtering required schema elements. Furthermore, instead of filtering contextual information, we highlight techniques such as augmentation, selection, and correction, and adopt them to improve the accuracy of our Text-to-SQL pipeline. Our approach ranks first on the BIRD benchmark achieving an accuracy of 71.83%.

📄 PDF Abstract BibTeX arXiv:2408.07702

Code (0)

등록된 구현이 없습니다.

Tasks

Natural Language QueriesText to SQLText-To-SQL

Similar Papers 제목 키워드 기반

Re-examining the Role of Schema Linking in Text-to-SQL

2020-11-01 · EMNLP 2020 11 · Wenqiang Lei, Weixin Wang, Zhixin Ma, Tian Gan 외

In existing sophisticated text-to-SQL models, schema linking is often considered as a simple, minor component, belying its importance. By providing a schema linking corpus based on the Spider text-to-SQL dataset, we syst…

Text to SQLText-To-SQL

Knapsack Optimization-based Schema Linking for LLM-based Text-to-SQL Generation

2025-02-18 · Zheng Yuan, Hao Chen, Zijin Hong, Qinggang Zhang 외

Generating SQLs from user queries is a long-standing challenge, where the accuracy of initial schema linking significantly impacts subsequent SQL generation performance. However, current schema linking models still strug…

Text to SQLText-To-SQL

Schema-R1: A reasoning training approach for schema linking in Text-to-SQL Task

2025-06-13 · Wuzhenghong Wen, Su Pan, Yuwei Sun

Schema linking is a critical step in Text-to-SQL task, aiming to accurately predict the table names and column names required for the SQL query based on the given question. However, current fine-tuning approaches for sch…

reinforcement-learningReinforcement LearningText to SQLText-To-SQL

AutoLink: Autonomous Schema Exploration and Expansion for Scalable Schema Linking in Text-to-SQL at Scale

2025-11-21 · Ziyang Wang, Yuanlei Zheng, Zhenbiao Cao, Xiaojin Zhang 외 arxiv

For industrial-scale text-to-SQL, supplying the entire database schema to Large Language Models (LLMs) is impractical due to context window limits and irrelevant noise. Schema linking, which filters the schema to a relev…

PSM-SQL: Progressive Schema Learning with Multi-granularity Semantics for Text-to-SQL

2025-02-07 · Zhuopan Yang, Yuanzhen Xie, Ruichao Zhong, Yunzhi Tan 외

It is challenging to convert natural language (NL) questions into executable structured query language (SQL) queries for text-to-SQL tasks due to the vast number of database schemas with redundancy, which interferes with…

Text to SQLText-To-SQLTriplet