DBScholar

Back to papers

LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning

Summary: Constraint-aware SQL generation via RL: LearnedSQLGen steers query synthesis toward constraint satisfaction using exploration–exploitation and execution feedback. Finite-state machine enforces valid SQL; benchmarks show ~30% accuracy gain and 10–35× speedups. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
6528
Venue
SIGMOD
Year
2022
Pagerank
6.3349035e-05
Overall Rank
5,169 | 64.54%
DOI
10.1145/3514221.3526155

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{zhang_sigmod22,
        title = {{LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning}},
        author = {Zhang, Lixi and Chai, Chengliang and Zhou, Xuanhe and Li, Guoliang},
        series = {{SIGMOD} '22},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3514221.3526155},
        url = {https://dl.acm.org/doi/10.1145/3514221.3526155},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 11 of 11 citing papers.

Rank Citing Paper Year Venue Pagerank
2,762 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 8.1539867e-05
6,327 Breaking It Down: An In-depth Study of Index Advisors 2024 VLDB 5.9124005e-05
8,042 Grep: A Graph Learning Based Database Partitioning System 2023 SIGMOD 5.5015896e-05
8,048 WISK: A Workload-aware Learned Index for Spatial Keyword Queries 2023 SIGMOD 5.5003171e-05
8,453 A Learned Query Rewrite System 2023 VLDB 5.4229225e-05
9,024 Demonstrating SQLBarber: Leveraging Large Language Models to Generate Customized and Realistic SQL Workloads 2025 SIGMOD 5.3299884e-05
9,047 SQL-Factory: A Multi-Agent Framework for High-Quality and Large-Scale SQL Generation 2026 VLDB 5.3251649e-05
9,490 Robustness of Updatable Learning-based Index Advisors against Poisoning Attack 2024 SIGMOD 5.2629522e-05
9,777 PBench: Workload Synthesizer with Real Statistics for Cloud Analytics Benchmarking 2025 VLDB 5.2209769e-05
10,445 Divo: Learning a Stable and Effective Query Optimizer with a Diverse Workload 2026 SIGMOD 5.093636e-05
10,501 SQLBarber: A System Leveraging Large Language Models to Generate Customized and Realistic SQL Workloads 2026 SIGMOD 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 27 of 27 cited papers.

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

Rank Cited Paper Year Venue Pagerank
176 Deep Learning for Entity Matching: A Design Space Exploration 2018 SIGMOD 0.00027191081
334 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00020875082
392 Massive Stochastic Testing of SQL 1998 VLDB 0.00019342814
447 ALEX: An Updatable Adaptive Learned Index 2020 SIGMOD 0.00018322593
498 QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning 2019 VLDB 0.00017440583
682 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB 0.00015014887
873 Learning Multi-dimensional Indexes 2020 SIGMOD 0.00013481915
1,122 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.0001209124
1,344 An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems 2021 VLDB 0.00011094717
1,832 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 9.6607418e-05
1,942 Design Continuums and the Path Toward Self-Designing Key-Value Stores that Know and Learn 2019 CIDR 9.4451535e-05
2,069 Generating Targeted Queries for Database Testing 2008 SIGMOD 9.2293717e-05
2,452 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5584e-05
2,812 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 8.0979597e-05
2,888 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.9941489e-05
3,460 DIAMetrics: Benchmarking Query Engines at Scale 2020 VLDB 7.3939262e-05
3,688 FACE: A Normalizing Flow based Cardinality Estimator 2022 VLDB 7.201795e-05
3,961 MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems 2021 SIGMOD 6.987575e-05
4,082 SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns 2020 SIGMOD 6.9164719e-05
4,101 Automated Generation of Materialized Views in Oracle 2020 VLDB 6.9009734e-05
4,111 A genetic approach for random testing of database systems 2007 VLDB 6.8945321e-05
4,789 Learned Approximate Query Processing: Make it Light, Accurate and Fast 2021 CIDR 6.5072039e-05
4,808 Selective Data Acquisition in the Wild for Model Charging 2022 VLDB 6.4991553e-05
5,340 Machine Learning for Databases 2021 VLDB 6.2603359e-05
5,524 Database Benchmarking for Supporting Real-Time Interactive Querying of Large Data 2020 SIGMOD 6.1868208e-05
6,899 Human-in-the-loop Outlier Detection 2020 SIGMOD 5.7431609e-05
7,394 DBMind: A Self-Driving Platform in openGauss 2021 VLDB 5.6259065e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,553 LLM-R^2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency 2025 VLDB
2 8,815 Supporting Database Constraints in Synthetic Data Generation based on Generative Adversarial Networks 2020 SIGMOD
3 1,815 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2018 VLDB
4 6,271 Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective 2024 VLDB
5 5,132 Facilitating SQL Query Composition and Analysis 2020 SIGMOD
6 2,723 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB
7 9,047 SQL-Factory: A Multi-Agent Framework for High-Quality and Large-Scale SQL Generation 2026 VLDB
8 2,369 Data Generation using Declarative Constraints 2011 SIGMOD
9 3,051 Towards a Hands-Free Query Optimizer through Deep Learning 2019 CIDR
10 10,285 Reward-SQL: Boosting Text-to-SQL via Stepwise Execution-Aware Reasoning and Process-Supervised Rewards 2026 SIGMOD