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
h0b4320c7c59895d8
Venue
VLDB
Year
2025
Pagerank
5.4198293e-05
Overall Rank
7,952 | 46.54%
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 2 of 2 citing papers.

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
174 Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation 2024 VLDB 0.00026790979
180 Constructing an Interactive Natural Language Interface for Relational Databases 2015 VLDB 0.0002654471
439 ATHENA: An Ontology-Driven System for Natural Language Querying over Relational Data Stores 2016 VLDB 0.00018251249
533 CodeS: Towards Building Open-source Language Models for Text-to-SQL 2024 SIGMOD 0.00016826571
536 NaLIR: An Interactive Natural Language Interface for Querying Relational Databases 2014 SIGMOD 0.00016771934
776 Natural language to SQL: Where are we today? 2020 VLDB 0.00014063545
1,356 CatSQL: Towards Real World Natural Language to SQL Applications 2023 VLDB 0.00010925509
1,680 Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries 2018 VLDB 9.9031411e-05
1,866 ScienceBenchmark: A Complex Real-World Benchmark for Evaluating Natural Language to SQL Systems 2024 VLDB 9.481643e-05
2,467 Few-shot Text-to-SQL Translation using Structure and Content Prompt Learning 2023 SIGMOD 8.4211526e-05
3,418 Data Profiling – A Tutorial 2017 SIGMOD 7.3210362e-05
4,331 FinSQL: Model-Agnostic LLMs-based Text-to-SQL Framework for Financial Analysis 2024 SIGMOD 6.6590534e-05
4,617 QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster 2020 SIGMOD 6.49965e-05
4,847 Explaining Wrong Queries Using Small Examples 2019 SIGMOD 6.3823876e-05
4,857 A SQL Debugger Built from Spare Parts: Turning a SQL:1999 Database System into Its Own Debugger 2015 SIGMOD 6.3794096e-05
5,155 An In-Depth Benchmarking of Text-to-SQL Systems 2021 SIGMOD 6.250495e-05
8,972 Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries 2024 SIGMOD 5.2458797e-05
9,061 Understanding Queries by Conditional Instances 2022 SIGMOD 5.2289882e-05
Previous Page 1 / 1 Next

Semantically Similar Papers