Cracking SQL Barriers: An LLM-based Dialect Translation System

Summary: CrackSQL leverages LLMs to translate SQL dialects via function-based segmentation, normalization, and translation-irrelevant abstraction for long, multi-syntax queries. A Cross-Dialect Syntax Embedding Model with a Local-to-Global loop enables targeted fixes and iterative translation. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 7212
Venue: SIGMOD
Year: 2025
Pagerank: 4.1945683e-05
Overall Rank: 10,475 | 27.13%
DOI: 10.1145/3725278

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
7,035	R-Bot: An LLM-based Query Rewrite System	2025	VLDB	4.8548467e-05
10,244	DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs	2026	VLDB	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 17 of 17 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
106	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.00048400734
219	Grammar-like Functional Rules for Representing Query Optimization Alternatives	1988	SIGMOD	0.00033244259
340	OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases	2014	VLDB	0.00026841628
544	Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources	2018	SIGMOD	0.00020521965
984	Natural language to SQL: Where are we today?	2020	VLDB	0.00014857465
1,313	Cost-Based Optimization for Magic: Algebra and Implementation	1996	SIGMOD	0.0001263831
1,956	D-Bot: Database Diagnosis System using Large Language Models	2024	VLDB	9.960627e-05
2,596	WeTune: Automatic Discovery and Verification of Query Rewrite Rules	2022	SIGMOD	8.4729982e-05
3,114	GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization	2024	VLDB	7.5451724e-05
3,248	A Learned Query Rewrite System using Monte Carlo Tree Search	2022	VLDB	7.3258782e-05
3,472	LLM-R2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency	2025	VLDB	7.0639229e-05
3,662	The Dawn of Natural Language to SQL: Are We Fully Ready?	2024	VLDB	6.8672143e-05
4,238	Panda: Performance Debugging for Databases using LLM Agents	2024	CIDR	6.331901e-05
5,023	GenRewrite: Query Rewriting via Large Language Models	2026	SIGMOD	5.75363e-05
5,915	Runtime-Extensible Parsers	2025	CIDR	5.274713e-05
6,750	Breaking It Down: An In-depth Study of Index Advisors	2024	VLDB	4.9392771e-05
7,020	LLM for Data Management	2024	VLDB	4.8595728e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,472	LLM-R2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency	2025	VLDB	7.0639229e-05
4,908	Combining Small Language Models and Large Language Models for Zero-Shot NL2SQL	2024	VLDB	5.8339245e-05
2,988	NL2SQL is a solved problem... Not!	2024	CIDR	7.7761714e-05
7,354	Reliable Text-to-SQL with Adaptive Abstention	2025	SIGMOD	4.7529612e-05
984	Natural language to SQL: Where are we today?	2020	VLDB	0.00014857465
10,837	Natural Language to SQL: State of the Art and Open Problems	2025	VLDB	4.1945683e-05
9,151	The Power of Constraints in Natural Language to SQL Translation	2025	VLDB	4.3849295e-05
369	Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation	2024	VLDB	0.0002547515
7,139	Automated Validating and Fixing of Text-to-SQL Translation with Execution Consistency	2025	SIGMOD	4.821174e-05
10,796	Horizon: Robust Checks for SQL Migration Using LLMs	2025	VLDB	4.1945683e-05