Metasql: A Generate-Then-Rank Framework for Natural Language to SQL Translation

Fan, Yuankai; He, Zhenying; Ren, Tonghui; Huang, Can; Jing, Yinan; Zhang, Kai; Wang, X. Sean

doi:10.1109/icde60146.2024.00143

Search citation statements

Order By: Relevance

Paper Sections

Select...

Citation Types

Supporting

Mentioning

Contrasting

Year Published

2024

Publication Types

Select...

Book1

Other1

Preprint1

Relationship

Self Cite0

Independent3

Authors

Journals

Cited by 3 publications

References 45 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

Gar $$\scriptstyle ++$$: Natural Language to SQL Translation with Efficient Generate-and-Rank

Fan,

Huang,

Ren

et al. 2024

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Gar $$\scriptstyle ++$$: Natural Language to SQL Translation with Efficient Generate-and-Rank

Fan,

Huang,

Ren

et al. 2024

Lecture Notes in Computer Science

View full text Add to dashboard Cite

PURPLE: Making a Large Language Model a Better SQL Writer

Ren,

Fan,

et al. 2024

2024 IEEE 40th International Conference on Data Engineering (ICDE)

View full text Add to dashboard Cite

Optimizing Text-to-SQL Transformations: The Potential of Skeleton Decoupling in SKT-SQL

Yi,

Chen

2024

Preprint

View full text Add to dashboard Cite

The Text-to-SQL technology faces significant challenges in converting natural language questions into SQL code, particularly in handling complexities and diversities in multi-domain and high-complexity tasks. To address these issues, this paper proposes a novel framework, SKT-SQL, which effectively decomposes the key steps in Text-to-SQL transformation, such as skeleton generation and schema linking, through multi-decoupling and skeleton prompting strategies, thereby simplifying the entire process. SKT-SQL employs a schema decoupler to filter relevant schema items linked to the natural language questions, reducing the burden on the model during the parsing process. Concurrently, the skeleton generator guides the language model in generating accurate SQL questions using an abstract SQL skeleton representation. This innovative strategy significantly enhances the accuracy of SQL skeleton generation using smaller-scale language models and optimizes the final SQL query generation results. The core contribution of this paper lies in the analysis of the potential of skeleton-based decoupling, demonstrating the advantages of SKT-SQL in improving the accuracy of Text-to-SQL generation, and providing new insights for future Text-to-SQL methods. Experimental validation on the Spider dataset shows that SKT-SQL excels in execution accuracy (EX) and exact-match accuracy (EM), showcasing its robust potential in complex query scenarios.

show abstract

Metasql: A Generate-Then-Rank Framework for Natural Language to SQL Translation

Cited by 3 publications

References 45 publications

Gar $$\scriptstyle ++$$: Natural Language to SQL Translation with Efficient Generate-and-Rank

Gar $$\scriptstyle ++$$: Natural Language to SQL Translation with Efficient Generate-and-Rank

PURPLE: Making a Large Language Model a Better SQL Writer

Optimizing Text-to-SQL Transformations: The Potential of Skeleton Decoupling in SKT-SQL

Contact Info

Product

Resources

About