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: 7213
Venue: SIGMOD
Year: 2025
Pagerank: 4.1905499e-05
Overall Rank: 10,485 | 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,030	R-Bot: An LLM-based Query Rewrite System	2025	VLDB	4.8518029e-05
10,244	DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs	2026	VLDB	4.1905499e-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
107	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.00048363446
220	Grammar-like Functional Rules for Representing Query Optimization Alternatives	1988	SIGMOD	0.00033312045
339	OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases	2014	VLDB	0.00026895683
542	Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources	2018	SIGMOD	0.00020522627
973	Natural language to SQL: Where are we today?	2020	VLDB	0.0001488435
1,313	Cost-Based Optimization for Magic: Algebra and Implementation	1996	SIGMOD	0.00012629432
1,953	D-Bot: Database Diagnosis System using Large Language Models	2024	VLDB	9.9701097e-05
2,595	WeTune: Automatic Discovery and Verification of Query Rewrite Rules	2022	SIGMOD	8.4725961e-05
3,105	GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization	2024	VLDB	7.5567226e-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
3,666	The Dawn of Natural Language to SQL: Are We Fully Ready?	2024	VLDB	6.8606092e-05
4,234	Panda: Performance Debugging for Databases using LLM Agents	2024	CIDR	6.3300159e-05
5,001	GenRewrite: Query Rewriting via Large Language Models	2026	SIGMOD	5.7634197e-05
5,915	Runtime-Extensible Parsers	2025	CIDR	5.2696476e-05
6,753	Breaking It Down: An In-depth Study of Index Advisors	2024	VLDB	4.9345582e-05
7,016	LLM for Data Management	2024	VLDB	4.8561622e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,465	LLM-R2: A Large Language Model Enhanced Rule-based Rewrite System for Boosting Query Efficiency	2025	VLDB	7.0668293e-05
4,908	Combining Small Language Models and Large Language Models for Zero-Shot NL2SQL	2024	VLDB	5.835596e-05
2,987	NL2SQL is a solved problem... Not!	2024	CIDR	7.77529e-05
7,351	Reliable Text-to-SQL with Adaptive Abstention	2025	SIGMOD	4.7484027e-05
973	Natural language to SQL: Where are we today?	2020	VLDB	0.0001488435
10,841	Natural Language to SQL: State of the Art and Open Problems	2025	VLDB	4.1905499e-05
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
7,137	Automated Validating and Fixing of Text-to-SQL Translation with Execution Consistency	2025	SIGMOD	4.8165495e-05
10,802	Horizon: Robust Checks for SQL Migration Using LLMs	2025	VLDB	4.1905499e-05