Natural language to SQL in low-code platforms

Sofia Aparicio, Samuel Arcadinho, João Nadkarni, David Aparício, João Lages +3 more
8/29/2023
cs.AI

No confident code implementation found for this paper. 5 possible matches can be shown below.

Abstract

One of the developers' biggest challenges in low-code platforms is retrieving data from a database using SQL queries. Here, we propose a pipeline allowing developers to write natural language (NL) to retrieve data. In this study, we collect, label, and validate data covering the SQL queries most often performed by OutSystems users. We use that data to train a NL model that generates SQL. Alongside this, we describe the entire pipeline, which comprises a feedback loop that allows us to quickly collect production data and use it to retrain our SQL generation model. Using crowd-sourcing, we collect 26k NL and SQL pairs and obtain an additional 1k pairs from production data. Finally, we develop a UI that allows developers to input a NL query in a prompt and receive a user-friendly representation of the resulting SQL query. We use A/B testing to compare four different models in production and observe a 240% improvement in terms of adoption of the feature, 220% in terms of engagement rate, and a 90% decrease in failure rate when compared against the first model that we put into production, showcasing the effectiveness of our pipeline in continuously improving our feature.

View on arXivView PDF

Code Implementations

No confident code match yet

We couldn't find an author-owned or strongly-evidenced community implementation for this paper. 5 weaker matches are hidden by default — verify before relying on them.

No code implementations found yet.

Know of an implementation? Let us know in the comments below!

Similar Papers

Cite this paper

@article{aparicio2023natural,
  title  = {Natural language to SQL in low-code platforms},
  author = {Sofia Aparicio and Samuel Arcadinho and João Nadkarni and David Aparício and João Lages and Mariana Lourenço and Bartłomiej Matejczyk and Filipe Assunção},
  year   = {2023},
  eprint = {2308.15239},
  archivePrefix = {arXiv},
  url    = {http://arxiv.org/abs/2308.15239v1}
}

Add a badge to your README

Shows whether official code is linked for this paper.

Code of Paper badge
[![Code of Paper](https://codeofpaper.com/badge/2308.15239.svg)](https://codeofpaper.com/paper/2308.15239)

Discussion