Back to papers
GenRewrite: Query Rewriting via Large Language Models
Summary: GenRewrite: first holistic LLM-based query rewriting system beyond fixed rules, using Natural Language Rewrite Rules (NLR2s) to transfer rewrite knowledge across queries. Counterexample-guided repair iteratively fixes syntactic/semantic errors, outperforming rule-based and synthesis baselines on TPC-DS/JOB and SQLStorm variants.
(summarized by gpt-5-mini on Apr 11 2026)
- Paper ID
- 7511
- Venue
- SIGMOD
- Year
- 2026
- Pagerank
- 5.7634197e-05
- Overall Rank
- 5,001 | 65.25%
- DOI
-
10.1145/3786684
Incoming Non-self Citations Over Time
Incoming Citations (Sorted by Pagerank)
Showing 11 of 11 citing papers.
| Rank |
Citing Paper |
Year |
Venue |
Pagerank |
| 5,429 |
Logical and Physical Optimizations for SQL Query Execution over Large Language Models |
2025 |
SIGMOD |
5.511638e-05 |
| 7,016 |
LLM for Data Management |
2024 |
VLDB |
4.8561622e-05 |
| 7,030 |
R-Bot: An LLM-based Query Rewrite System |
2025 |
VLDB |
4.8518029e-05 |
| 7,887 |
SQLStorm: Taking Database Benchmarking into the LLM Era |
2025 |
VLDB |
4.6218382e-05 |
| 9,992 |
Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! |
2026 |
CIDR |
4.1905499e-05 |
| 10,047 |
AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning |
2026 |
SIGMOD |
4.1905499e-05 |
| 10,096 |
NeuSO: Neural Optimizer for Subgraph Queries |
2026 |
SIGMOD |
4.1905499e-05 |
| 10,219 |
Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking |
2026 |
SIGMOD |
4.1905499e-05 |
| 10,485 |
Cracking SQL Barriers: An LLM-based Dialect Translation System |
2025 |
SIGMOD |
4.1905499e-05 |
| 10,507 |
PLM4NDV: Minimizing Data Access for Number of Distinct Values Estimation with Pre-trained Language Models |
2025 |
SIGMOD |
4.1905499e-05 |
| 10,784 |
GRewriter: Practical Query Rewriting with Automatic Rule Set Expansion in GaussDB |
2025 |
VLDB |
4.1905499e-05 |
Outgoing Citations (Sorted by Pagerank)
Showing 22 of 22 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank |
Cited Paper |
Year |
Venue |
Pagerank |
| 71 |
How Good Are Query Optimizers, Really? |
2016 |
VLDB |
0.00059446482 |
| 107 |
Extensible/Rule Based Query Rewrite Optimization in Starburst |
1992 |
SIGMOD |
0.00048363446 |
| 167 |
The Snowflake Elastic Data Warehouse |
2016 |
SIGMOD |
0.00039408116 |
| 366 |
Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation |
2024 |
VLDB |
0.00025580097 |
| 516 |
Can Foundation Models Wrangle Your Data? |
2023 |
VLDB |
0.00021194444 |
| 542 |
Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources |
2018 |
SIGMOD |
0.00020522627 |
| 991 |
Improved Unnesting Algorithms for Join Aggregate SQL Queries |
1992 |
VLDB |
0.00014797083 |
| 1,313 |
Cost-Based Optimization for Magic: Algebra and Implementation |
1996 |
SIGMOD |
0.00012629432 |
| 1,404 |
DB-BERT: A Database Tuning Tool that "Reads the Manual" |
2022 |
SIGMOD |
0.00012179714 |
| 1,731 |
CatSQL: Towards Real World Natural Language to SQL Applications |
2023 |
VLDB |
0.00010723825 |
| 1,921 |
Selecting Subexpressions to Materialize at Datacenter Scale |
2018 |
VLDB |
0.00010085899 |
| 1,953 |
D-Bot: Database Diagnosis System using Large Language Models |
2024 |
VLDB |
9.9701097e-05 |
| 2,513 |
Annotating Columns with Pre-trained Language Models |
2022 |
SIGMOD |
8.6155767e-05 |
| 2,585 |
Table-GPT: Table Fine-tuned GPT for Diverse Table Tasks |
2024 |
SIGMOD |
8.4909917e-05 |
| 2,595 |
WeTune: Automatic Discovery and Verification of Query Rewrite Rules |
2022 |
SIGMOD |
8.4725961e-05 |
| 3,241 |
A Learned Query Rewrite System using Monte Carlo Tree Search |
2022 |
VLDB |
7.32744e-05 |
| 3,465 |
LLM-R2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency |
2025 |
VLDB |
7.0668293e-05 |
| 4,385 |
Proving Query Equivalence Using Linear Integer Arithmetic |
2023 |
SIGMOD |
6.2247394e-05 |
| 7,030 |
R-Bot: An LLM-based Query Rewrite System |
2025 |
VLDB |
4.8518029e-05 |
| 7,887 |
SQLStorm: Taking Database Benchmarking into the LLM Era |
2025 |
VLDB |
4.6218382e-05 |
| 8,339 |
SlabCity: Whole-Query Optimization using Program Synthesis |
2023 |
VLDB |
4.5383933e-05 |
| 8,502 |
New Query Optimization Techniques in the Spark Engine of Azure Synapse |
2022 |
VLDB |
4.491819e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 9,151 |
The Power of Constraints in Natural Language to SQL Translation |
2025 |
VLDB |
4.380727e-05 |
| 366 |
Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation |
2024 |
VLDB |
0.00025580097 |
| 8,479 |
Can Large Language Models Be Query Optimizer for Relational Databases? |
2026 |
SIGMOD |
4.4967983e-05 |
| 5,429 |
Logical and Physical Optimizations for SQL Query Execution over Large Language Models |
2025 |
SIGMOD |
5.511638e-05 |
| 8,975 |
A Learned Query Rewrite System |
2023 |
VLDB |
4.4146872e-05 |
| 7,887 |
SQLStorm: Taking Database Benchmarking into the LLM Era |
2025 |
VLDB |
4.6218382e-05 |
| 4,281 |
GenEdit: Compounding Operators and Continuous Improvement to Tackle Text-to-SQL in the Enterprise |
2025 |
CIDR |
6.2824978e-05 |
| 7,030 |
R-Bot: An LLM-based Query Rewrite System |
2025 |
VLDB |
4.8518029e-05 |
| 9,992 |
Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More! |
2026 |
CIDR |
4.1905499e-05 |
| 3,465 |
LLM-R2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency |
2025 |
VLDB |
7.0668293e-05 |