arrow
Return

Horizon: Robust Checks for SQL Migration Using LLMs

delete2025-08-01
delete0
PRE
AI
V
Venkatesh Emani *
W
Wenjing Wang
Z
Zi Ye
H
He, Jia
N
N. W. Ball
K
K. S. Boora
C
Carlo Curino
A
Avrilia Floratou
G
Goenka, Manan
P
Paridhi Gupta
V
Vivek Gupta
K
Katherine Lin
N
Nick Litombe
J
Jared Meade
S
Suryakant Mutnal
M
Mark Pryce-Maher
R
Raghu Ramakrishnan
S
Sudhir Raparla
D
Dhruv Relwani
S
Shyam Sai
V
Vaibhave Sekar
S
Shaw, Roneet
H
Harmeet Singh
M
Mark Taylor
S
Sunidhi Tiwari
Y
Yiwen Zhu
DOI:10.14778/3750601.3750646delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
Large language models (LLMs) have recently demonstrated strong capabilities in code migration across languages, making them promising for SQL schema migration. However, achieving reliable and accurate SQL migration with LLMs remains a challenge. This paper presents the first comprehensive approach for practical and effective SQL schema migration using LLMs. We highlight the necessity of robust evaluation and iterative query refinement to achieve highly accurate migrations. Building on traditional database tools along with LLMs, we introduce novel checks to guide LLMs towards syntactically complete and functionally equivalent translations. Our approach supports all schema object types, including complex procedural constructs. Our demonstrations offer audience opportunities to explore our system using a variety of configurations, datasets and custom inputs, providing useful insights into the underlying techniques, their strengths, and limitations.

Journal

P
Proceedings of the VLDB Endowment
IF:
3.3
Papers:
553
Citations:
1.2W

Organization

M
Microsoft
Scholars:
3.0K
Papers: 2.7K
Citations: 7