DBScholar

Back to papers

Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation

Summary: Systematic benchmark of prompt-engineering components (question representation, example selection/organization) and token-efficiency for LLM-based Text-to-SQL. Proposes DAIL-SQL (86.6% execution on Spider) and evaluates open-source LLMs with supervised fine-tuning, revealing accuracy/efficiency/cost trade-offs. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
h37b8ad61902e832d
Venue
VLDB
Year
2024
Pagerank
0.00027456647
Overall Rank
163 | 98.91%
DOI
10.14778/3641204.3641221
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{gao_vldb24,
        title = {{Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation}},
        author = {Gao, Dawei and Wang, Haibin and Qian, Yichen and Li, Yaliang and Ding, Bolin and Sun, Xiuyu and Zhou, Jingren},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {5},
        pages = {1132--1145},
        doi = {10.14778/3641204.3641221},
        url = {https://doi.org/10.14778/3641204.3641221},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 67 citing papers.

Rank Citing Paper Year Venue Pagerank
501 CodeS: Towards Building Open-source Language Models for Text-to-SQL 2024 SIGMOD 0.00017239952
1,789 OmniSQL: Synthesizing High-quality Text-to-SQL Data at Scale 2025 VLDB 9.628035e-05
1,977 OpenSearch-SQL: Enhancing Text-to-SQL with Dynamic Few-shot and Consistency Alignment 2025 SIGMOD 9.2659291e-05
2,117 The Dawn of Natural Language to SQL: Are We Fully Ready? 2024 VLDB 9.0012524e-05
3,158 GenRewrite: Query Rewriting via Large Language Models 2026 SIGMOD 7.5676704e-05
3,358 Combining Small Language Models and Large Language Models for Zero-Shot NL2SQL 2024 VLDB 7.3650961e-05
3,899 FinSQL: Model-Agnostic LLMs-based Text-to-SQL Framework for Financial Analysis 2024 SIGMOD 6.9199448e-05
4,583 QUEST: Query Optimization in Unstructured Document Analysis 2025 VLDB 6.5079225e-05
4,689 SNAILS: Schema Naming Assessments for Improved LLM-Based SQL Inference 2025 SIGMOD 6.4513088e-05
4,812 Hybrid Querying Over Relational Databases and Large Language Models 2025 CIDR 6.3907046e-05
4,851 Is Long Context All You Need? Leveraging LLM's Extended Context for NL2SQL 2025 VLDB 6.3681831e-05
4,917 Automated Validating and Fixing of Text-to-SQL Translation with Execution Consistency 2025 SIGMOD 6.3447485e-05
6,235 GenEdit: Compounding Operators and Continuous Improvement to Tackle Text-to-SQL in the Enterprise 2025 CIDR 5.8248698e-05
6,528 Reliable Text-to-SQL with Adaptive Abstention 2025 SIGMOD 5.7375274e-05
7,972 The Power of Constraints in Natural Language to SQL Translation 2025 VLDB 5.3993508e-05
8,037 Generating Succinct Descriptions of Database Schemata for Cost-Efficient Prompting of Large Language Models 2024 VLDB 5.3863017e-05
8,311 ELT-Bench: An End-to-End Benchmark for Evaluating AI Agents on ELT Pipelines 2026 VLDB 5.3410298e-05
8,320 ThriftLLM: On Cost-Effective Selection of Large Language Models for Classification Queries 2025 VLDB 5.3404439e-05
8,368 LEAP: LLM-powered End-to-end Automatic Library for Processing Social Science Queries on Unstructured Data 2025 VLDB 5.3292904e-05
8,696 Self-Enhancing Video Data Management System for Compositional Events with Large Language Models 2025 SIGMOD 5.2717835e-05
8,916 mLoRA: Fine-Tuning LoRA Adapters via Highly-Efficient Pipeline Parallelism in Multiple GPUs 2025 VLDB 5.2361195e-05
8,917 Optimized Batch Prompting for Cost-effective LLMs 2025 VLDB 5.2361195e-05
9,098 Unveiling Challenges for LLMs in Enterprise Data Engineering 2026 VLDB 5.208561e-05
9,242 Natural Language to SQL: State of the Art and Open Problems 2025 VLDB 5.1864799e-05
9,251 Text-to-SQL Benchmarks are Broken: An In-Depth Analysis of Annotation Errors 2026 CIDR 5.1860131e-05
9,256 SQL-Factory: A Multi-Agent Framework for High-Quality and Large-Scale SQL Generation 2026 VLDB 5.1860131e-05
9,338 Sphinteract: Resolving Ambiguities in NL2SQL Through User Interaction 2025 VLDB 5.1782134e-05
9,842 CatDB: Data-catalog-guided, LLM-based Generation of Data-centric ML Pipelines 2025 VLDB 5.1064323e-05
9,946 AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning 2026 SIGMOD 5.0910746e-05
9,994 Evoschema: Towards Text-To-Sql Robustness Against Schema Evolution 2025 VLDB 5.0845476e-05
10,170 ParSEval: Plan-aware Test Database Generation for SQL Equivalence Evaluation 2025 VLDB 5.0559291e-05
10,234 CEDAR: A System for Cost-Efficient Data-Driven Claim Verification 2025 VLDB 5.0432098e-05
10,371 QueryArtisan: Generating Data Manipulation Codes for Ad-hoc Analysis in Data Lakes 2025 VLDB 5.0010514e-05
10,382 Automated Database Testing via LLM-Synthesized SQL Features 2027 SIGMOD 4.9605343e-05
10,383 Benchmarking Text-to-SQL under Role-Based Access Control 2027 SIGMOD 4.9605343e-05
10,411 TACO: Token-Aware Context Optimization for Structured OpenStreetMap Query Generation 2027 SIGMOD 4.9605343e-05
10,510 DBugScribe: Automatic Database Bug Reproduction from Community Reports 2026 SIGMOD 4.9605343e-05
10,511 DeepEye-SQL: A Software-Engineering-Inspired Text-to-SQL Framework 2026 SIGMOD 4.9605343e-05
10,514 Dialect-Agnostic SQL Parsing via LLM-Based Segmentation 2026 SIGMOD 4.9605343e-05
10,539 Generalized Entity Matching with Adaptivity via Large Language Models 2026 SIGMOD 4.9605343e-05
10,565 OctoSelector: Efficient and Effective Batch-Aware Model Selection for Large Language Models 2026 SIGMOD 4.9605343e-05
10,574 Reward-SQL: Boosting Text-to-SQL via Stepwise Execution-Aware Reasoning and Process-Supervised Rewards 2026 SIGMOD 4.9605343e-05
10,621 Are Your LLM-based Text-to-SQL Models Secure? Exploring SQL Injection via Backdoor Attacks 2026 SIGMOD 4.9605343e-05
10,634 Drama: Unifying Data Retrieval and Analysis for Open-Domain Analytic Queries 2026 SIGMOD 4.9605343e-05
10,658 PLForge: Enhancing Language Models for Natural Language to Procedural Extensions of SQL 2026 SIGMOD 4.9605343e-05
10,667 Reliable Answers for Recurring Questions: Boosting Text-to-SQL Accuracy with Template Constrained Decoding 2026 SIGMOD 4.9605343e-05
10,668 SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer 2026 SIGMOD 4.9605343e-05
10,704 DIVER: A Robust Text-to-SQL System with Dynamic Interactive Value Linking and Evidence Reasoning 2026 SIGMOD 4.9605343e-05
10,742 PRISM: Navigating Cost–Accuracy Trade-offs for NL2SQL 2026 SIGMOD 4.9605343e-05
10,766 NL2SQLBench: A Modular Benchmarking Framework for LLM-Enabled NL2SQL Solutions 2026 VLDB 4.9605343e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Previous Page 1 / 1 Next

Semantically Similar Papers