A big problem with Natural Language Interfaces to Databases (NLIDBs) is that they can't turn natural language queries into SQL instructions. The primary causes are linguistic ambiguity, schema complexity, and the challenges non-experts face in articulating relational data objectives. This paper examines the progression of Text-to-SQL methodologies from rule-based and statistical frameworks to deep neural architectures and ultimately to Large Language Models. It compares them to the Spider and WikiSQL benchmarks. Evidence indicates that LLMs, particularly GPT-4-class models, enhance execution accuracy via contextual reasoning and in-context learning; nonetheless, challenges persist in multilingual generalization, complex query management, and robustness across various database schemas. The study also shows how quick engineering, schema linking, and retrieval-augmented methods may fill these gaps and lower the cost of making queries. These improvements show that data interaction models are moving toward ones that are easier to use, more conversational, and allow for more than one way to participate. This makes databases easier for non-technical individuals to use and helps people in various fields make decisions based on data.
ahmed,Y. baderaldeen and Yaqoub,R. Yousif (2025). Generative AI for Relational Database Management: A Comprehensive Review of Natural Language Interfaces for Text-to-SQL Conversion. Al-Noor Journal for Information Technology and Cybersecurity, 2(2), 85-94. doi: 10.69513/jncs.v2.i2.a12
MLA
ahmed,Y. baderaldeen, and Yaqoub,R. Yousif. "Generative AI for Relational Database Management: A Comprehensive Review of Natural Language Interfaces for Text-to-SQL Conversion", Al-Noor Journal for Information Technology and Cybersecurity, 2, 2, 2025, 85-94. doi: 10.69513/jncs.v2.i2.a12
HARVARD
ahmed Y. baderaldeen, Yaqoub R. Yousif (2025). 'Generative AI for Relational Database Management: A Comprehensive Review of Natural Language Interfaces for Text-to-SQL Conversion', Al-Noor Journal for Information Technology and Cybersecurity, 2(2), pp. 85-94. doi: 10.69513/jncs.v2.i2.a12
CHICAGO
Y. baderaldeen ahmed and R. Yousif Yaqoub, "Generative AI for Relational Database Management: A Comprehensive Review of Natural Language Interfaces for Text-to-SQL Conversion," Al-Noor Journal for Information Technology and Cybersecurity, 2 2 (2025): 85-94, doi: 10.69513/jncs.v2.i2.a12
VANCOUVER
ahmed Y. baderaldeen, Yaqoub R. Yousif Generative AI for Relational Database Management: A Comprehensive Review of Natural Language Interfaces for Text-to-SQL Conversion. NJITC, 2025; 2(2): 85-94. doi: 10.69513/jncs.v2.i2.a12
