QuerySpeak: From Human Language to Database Queries
Tadi Sai Vishruth Reddy, Talluri Charitha, T. Sathwik, V Samitha, Niharika Panda · 2024
The project introduces a new Natural Language to SQL Query Converter implemented using Lex and Yacc tools. We aim to bridge the separation between human-readable statements and machine-executable SQL queries. By leveraging Lex for tokenization and Yacc for parsing, the system expertly navigates the conversion process, precisely extracting vital components from input statements. The Lex and Yacc implementations rely heavily on precise grammar rules to convert natural language expressions into SQL queries seamlessly. By encapsulating the semantics of typical database interactions, these rules enable the system to interpret user intentions and translate them into a suitable format for database execution. We will be implementing three main components in this project. The first involves inserting new statements and updating existing statements as needed. And lastly, we will be displaying the requested information. This project will showcase the impressive capabilities of Lex and Yacc as they convert unstructured natural language into structured database queries that can be efficiently executed.