DBScholar

Back to papers

The Power of Constraints in Natural Language to SQL Translation

Summary: REDSQL: plug-and-play refiner that uses constraint-driven extraction of relation summaries and data profiles over the entire DB to detect and fix semantic SQL errors beyond LLM context limits. Yields large NL2SQL gains (e.g., +8.8% CODES, +11.1% PURPLE on BIRD). (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
14050
Venue
VLDB
Year
2025
Pagerank
5.289545e-05
Overall Rank
9,305 | 36.16%
DOI
10.14778/3734839.3734847

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{ren_vldb25,
        title = {{The Power of Constraints in Natural Language to SQL Translation}},
        author = {Ren, Tonghui and Ke, Chen and Fan, Yuankai and Jing, Yinan and He, Zhenying and Zhang, Kai and Wang, X. Sean},
        journal = {PVLDB},
        series = {{VLDB} '25},
        volume = {18},
        number = {7},
        pages = {2097--2111},
        doi = {10.14778/3734839.3734847},
        url = {https://doi.org/10.14778/3734839.3734847},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank Citing Paper Year Venue Pagerank
10,556 OpenSQL: Data-Efficient Text-to-SQL for Open-Source LLMs via Synthesized Intermediate Supervision 2026 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 18 of 18 cited papers.

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

Rank Cited Paper Year Venue Pagerank
179 Constructing an Interactive Natural Language Interface for Relational Databases 2015 VLDB 0.00026838277
279 Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation 2024 VLDB 0.00022468369
459 ATHENA: An Ontology-Driven System for Natural Language Querying over Relational Data Stores 2016 VLDB 0.00018101318
555 NaLIR: An Interactive Natural Language Interface for Querying Relational Databases 2014 SIGMOD 0.00016568053
756 CodeS: Towards Building Open-source Language Models for Text-to-SQL 2024 SIGMOD 0.0001431656
865 Natural language to SQL: Where are we today? 2020 VLDB 0.00013521464
1,444 CatSQL: Towards Real World Natural Language to SQL Applications 2023 VLDB 0.00010769944
1,829 Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries 2018 VLDB 9.6671311e-05
2,039 ScienceBenchmark: A Complex Real-World Benchmark for Evaluating Natural Language to SQL Systems 2024 VLDB 9.2721259e-05
2,748 Few-shot Text-to-SQL Translation using Structure and Content Prompt Learning 2023 SIGMOD 8.1707811e-05
3,387 Data Profiling – A Tutorial 2017 SIGMOD 7.4534663e-05
4,251 FinSQL: Model-Agnostic LLMs-based Text-to-SQL Framework for Financial Analysis 2024 SIGMOD 6.8031106e-05
4,721 QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster 2020 SIGMOD 6.5444379e-05
4,759 Explaining Wrong Queries Using Small Examples 2019 SIGMOD 6.5207388e-05
4,961 A SQL Debugger Built from Spare Parts: Turning a SQL:1999 Database System into Its Own Debugger 2015 SIGMOD 6.4276648e-05
5,174 An In-Depth Benchmarking of Text-to-SQL Systems 2021 SIGMOD 6.3337874e-05
8,834 Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries 2024 SIGMOD 5.3599176e-05
8,970 Understanding Queries by Conditional Instances 2022 SIGMOD 5.3422757e-05
Previous Page 1 / 1 Next

Semantically Similar Papers