Our new X account is live! Follow @wizwand_team for updates
WorkDL logo mark

A Comprehensive Exploration on WikiSQL with Table-Aware Word Contextualization

About

We present SQLova, the first Natural-language-to-SQL (NL2SQL) model to achieve human performance in WikiSQL dataset. We revisit and discuss diverse popular methods in NL2SQL literature, take a full advantage of BERT {Devlin et al., 2018) through an effective table contextualization method, and coherently combine them, outperforming the previous state of the art by 8.2% and 2.5% in logical form and execution accuracy, respectively. We particularly note that BERT with a seq2seq decoder leads to a poor performance in the task, indicating the importance of a careful design when using such large pretrained models. We also provide a comprehensive analysis on the dataset and our model, which can be helpful for designing future NL2SQL datsets and models. We especially show that our model's performance is near the upper bound in WikiSQL, where we observe that a large portion of the evaluation errors are due to wrong annotations, and our model is already exceeding human performance by 1.3% in execution accuracy.

Wonseok Hwang, Jinyeong Yim, Seunghyun Park, Minjoon Seo• 2019

Related benchmarks

TaskDatasetResultRank
Natural Language to SQLWikiSQL (test)
Accuracy86.2
17
SQL Query GenerationWikiSQL (dev)
Accuracy87.2
13
Text-to-SQLWikiSQL original (dev)
Exact Match (EM)81.6
9
Text-to-SQLWikiSQL ADVETA-RPL
Exact Match (EM)27.2
9
Text-to-SQLWikiSQL ADVETA-ADD
Exact Match (EM)66.2
9
Text-to-SQLWikiSQL (dev)
Logic Form Acc80.6
8
Text-to-SQLWikiSQL (test)
Logic Form Accuracy80
8
Showing 7 of 7 rows

Other info

Follow for update