Automated SQL Query Generator by Understanding a Natural Language Statement
Amit Pagrut, Ishant Pakmode, Shambhoo Kariya, Vibhavari Kamble, Yashodhara V. Haribhakta · International Journal on Natural Language Computing · 2018
This project aims to develop a system which converts a natural language statement into MySQL query to retrieve information from respective database.The system mainly focuses on creation of complex queries which includes nested queries with more than two-level depth, queries with aggregate functions, having clause, group by clause and co-related queries which are formed due to constraint on aggregate function.The natural language input statement taken from the user is passed through various OpenNLP natural language processing techniques like Tokenization, Parts of Speech Tagging, Stemming and Lemmatization to get the statement in the desired form.The statement is further processed to extract the type of query, the basic clause, which specifies the required entities from the database and the condition clause, which specifies constraints on the basic clause.The final query is generated by converting the basic and condition clauses to their query form and then concatenating the condition query to the basic query.Currently, the system works only with MySQL database.