Data Agnostic RoBERTa-based Natural Language to SQL Query Generation

10/11/2020
by   Debaditya Pal, et al.
40

Relational databases are among the most widely used architectures to store massive amounts of data in the modern world. However, there is a barrier between these databases and the average user. The user often lacks the knowledge of a query language such as SQL required to interact with the database. The NL2SQL task aims at finding deep learning approaches to solve this problem by converting natural language questions into valid SQL queries. Given the sensitive nature of some databases and the growing need for data privacy, we have presented an approach with data privacy at its core. We have passed RoBERTa embeddings and data-agnostic knowledge vectors into LSTM based submodels to predict the final query. Although we have not achieved state of the art results, we have eliminated the need for the table data, right from the training of the model, and have achieved a test set execution accuracy of 76.7 a model capable of zero shot learning based on the natural language question and table schema alone.

READ FULL TEXT
research
07/28/2019

A Translate-Edit Model for Natural Language Question to SQL Query Generation on Multi-relational Healthcare Data

Electronic health record (EHR) data contains most of the important patie...
research
05/15/2020

Recent Advances in SQL Query Generation: A Survey

Natural language is hypothetically the best user interface for many doma...
research
03/16/2020

Duoquest: A Dual-Specification System for Expressive SQL Queries

Querying a relational database is difficult because it requires users to...
research
10/16/2022

AskYourDB: An end-to-end system for querying and visualizing relational databases using natural language

Querying databases for the right information is a time consuming and err...
research
11/01/2018

Embedding Individual Table Columns for Resilient SQL Chatbots

Most of the world's data is stored in relational databases. Accessing th...
research
04/25/2018

TypeSQL: Knowledge-based Type-Aware Neural Text-to-SQL Generation

Interacting with relational databases through natural language helps use...
research
12/30/2017

Bidirectional Attention for SQL Generation

Generating structural query language (SQL) queries from natural language...

Please sign up or login with your details

Forgot password? Click here to reset