Text to SQL Transformation Using LLM: A Comparative Research of T5, Seq2Seq, and SQLNet Models

2024

Closed access Metadata (CSL-JSON)
DOI 10.1109/ubmk63289.2024.10773579
Data confidence 70 medium
How this score is calculated

It is built from checkable properties of the record itself: whether the article has a DOI, how many independent sources confirmed its data, whether the required fields are filled in, and how recent the latest confirmation is. Disagreement between sources and a missing identifier lower it. A value of 80 or above means the record was published without further checking; 60 to 79 means it is published at reduced confidence, with a manual check advisable. A record verified by an editor by hand is never pushed below 90 by a recalculation. This scores our data about the article, not the article itself.

Abstract

The transformation of natural language text into SQL queries is a critical task in the domain of natural language processing and database management. This paper presents a comparative analysis of three prominent models: T5 (Text-to-Text Transfer Transformer), Seq2Seq (Sequence-to-Sequence), and SQLNet, applied to the Spider and WikiSQL dataset—a complex and diverse benchmark for text-to-SQL tasks. Leveraging the power of Large Language Models (LLM), we explore the efficacy, accuracy, and generalization capabilities of these models in transforming natural language queries into executable SQL statements