Papers › A Comprehensive Exploration on WikiSQL with Table-Aware Word Contextualization

A Comprehensive Exploration on WikiSQL with Table-Aware Word Contextualization

4 Feb 2019arXiv:1902.01069archive 2025-07-28

Wonseok Hwang, Jinyeong Yim, Seunghyun Park, Minjoon Seo

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.

PaperPDFCodeCode Syntology ranMethod as code

In Syntology View this paper on Syntology, its page in Syntology's graph. That page adds which of its functions are also present in other papers' code Syntology holds, with dates, and its dated run record as JSON and a README badge. It also lists the repositories linked to the paper, the abstract and the calls for agents.

Open this paper in Syntology's Atlas, the map of the papers in Syntology's graph and their citations.

For agents, on Syntology's MCP service (how to connect):

Code

Syntology 36 code samples: 35 from 4 repositories linked to this paper, 1 identical to code harvested from another paper's repository. Across all 36: 21 ran (of which 1 constructed an object rather than computing a result; 5 with no instrument failure: 2 honoured, 2 violated, 1 with no contract checked; 16 where Syntology's instrument failed) · 15 unverified. Where Syntology's instrument failed: 10 where our contract draft was wrong; 6 where the contract check could not run; failures of Syntology's instrument, not of the code.

By repository: official repository: 3 samples from 1 repository, 3 ran (2 with no instrument failure; 1 where Syntology's instrument failed); community (archive-listed): 32 samples from 3 repositories, 17 ran (3 with no instrument failure; 14 where Syntology's instrument failed); 1 identical to code first harvested elsewhere. The run record, sample by sample. “Ran” means executed on a synthesized input, not that the code is correct or reproduces the paper.

Levels written on 2026-09-22 (UTC): the dates Syntology's graph wrote each sample's verification level, not when the code executed. 1 of the 21 samples that ran has no recorded date.

naver/sqlova officialmentioned in papermentioned on GitHubpytorchSyntology: 3 samples, 3 ran (1 instrument-failed) · 0 unverified report
BroCoLySTyLe/SQLovaReview mentioned on GitHubSyntology: not harvested report
TooTouch/SPARTA mentioned on GitHubpytorchSyntology: 8 samples, 0 ran · 8 unverified report
qjay612/meta_learning_NL2SQL mentioned on GitHubpytorchSyntology: 22 samples, 15 ran (13 instrument-failed) · 7 unverified report
tanmay1618/text_to_sql_bert mentioned on GitHubpytorchSyntology: 2 samples, 2 ran (1 instrument-failed) · 0 unverified report

Repository list and official/mentioned flags are the archive's, frozen 2025-07-28. Reachability, where shown, is from one Syntology probe window (2026-09-16 to 2026-09-18); repositories not probed show nothing. GitHub stars are not tracked.

Code Syntology ran Syntology

36 samples harvested: 21 ran (of which 1 constructed an object rather than computing a result; 5 with no instrument failure: 2 honoured, 2 violated, 1 with no contract checked; 16 where Syntology's instrument failed) · 15 unverified. “Where Syntology's instrument failed” counts failures of Syntology's instrument, not of the code. Syntology's record for this page has not changed since , the first build that kept a record date for it; when this build read Syntology's graph is in the build record. That date is not when the samples ran.

2ran · honoured contract
2ran · violated contract
10ran · our draft was wrong
6ran; the contract check could not run
1ran
15unverified

Licence: 33 of the 36 samples are pointer only, meaning Syntology does not serve that copy's text. This page shows no code text for any sample; each one links to its file in the repository.

Harvested from 4 repositories linked to this paper, official or community; the list below is grouped by repository, each group headed by its name and what it is to the paper. 1 sample is listed last, in a group without a repository. “Ran” means the sample executed on a synthesized input. It does not mean the output is correct, and nothing here reproduces the paper's results. A line beginning “fixture:” under a sample that ran gives the arguments Syntology's fixture called the sample with, each as name:type/rank/element kind (? where none was recorded), and the type of what the fixture's run returned, exactly as the harness recorded them; the arguments and the returned type were recorded by two separate runs of the same fixture. No output value is shown, and a returned type says nothing about whether the output was right. “Level recorded” gives the UTC date when Syntology's graph wrote the sample's verification level, not when the code executed; where the level was written before Syntology's graph kept that date, the row says “level recorded, date not recorded”. “Honoured” and “violated” refer to a contract Syntology drafted from the code itself. “Our draft was wrong” and “the contract check could not run” are failures of Syntology's instrument, not of the code: the sample ran on Syntology's synthesized input, and then the drafted contract did not describe it, or the check itself raised an error (RAISES), lacked a dependency (DEP_MISSING) or ran out of time (TIMEOUT); hover the label for which. A metamorphic tier, where shown, is evidence of the output's shape, not that the sample implements the method.

Each sample ends with its code_sha256. A sample's code_sha256 is Syntology's identity for that exact code. It is printed in full (16 hexadecimal characters for every sample in this build), and get_code(code_sha256="…") takes it exactly as printed. An agent calls it on Syntology's MCP service (how to connect); click an identity to copy that call.

Repository labels, per sample. official repository: The archive marks this repository official for the paper. named in the paper: The archive records that the paper mentions this repository; it is not marked official. community (archive-listed): In the archive's code links for this paper, not marked official and not recorded as mentioned in the paper. found in paper text by Syntology: Syntology found this repository in the paper's own text; whether it is the authors' implementation is not asserted. community: Not in the archive's code links for this paper; a community repository Syntology harvested. Samples are grouped by repository: a repository marked official first, then by how directly the repository is tied to the paper, then in the archive's order; never by how many ran. Licence labels name the repository's licence as recorded at harvest. “Pointer only” means Syntology does not serve that copy's text, for one of six reasons: no licence file was found; the licence was not identified; the licence is recorded as permissive but that copy's record is not marked cleared; the licence is outside the permissive list Syntology serves text under (MIT, Apache-2.0, BSD and similar); this paper's copy was not located, so its licence is not recorded; or this paper's copy is cleared, but the stored copy of the same code that Syntology serves is not. Some licences outside that list permit redistribution, such as WTFPL, and GPL-3.0 under its conditions; they are simply not on the list. Hover a licence label for the reason. File links open the file on GitHub at the default branch, which may have changed since the harvest.

A function or class name links to its page when the name occurs in the harvested code of at least 5 papers; the name is a string, not an identity. A census tag appears when Syntology's census ran implementations with that name on one shared input per bucket: it gives how many were compared, from how many papers, and how many distinct outputs they produced, and names this sample's bucket when this sample was one of them.

naver/sqlova official repository 3 samples, 3 ran (1 instrument-failed) · 0 unverified
Loss_sa sqlova/model/nl2sql/wikisql_models.py ran · violated contract Apache-2.0 (permissive) · 3a0aeab0cd5f1c02 · report fixture: signature s_sa:Tensor/2/float, g_sa:list/1/int · returned Tensor · level recorded 2026-09-22
Loss_sc sqlova/model/nl2sql/wikisql_models.py ran · violated contract Apache-2.0 (permissive) · 176903678b9957e9 · report fixture: signature s_sc:Tensor/2/float, g_sc:list/1/int · returned Tensor · level recorded 2026-09-22
Loss_sw_se sqlova/model/nl2sql/wikisql_models.py ran; the contract check could not run (RAISES) · metamorphic tier: invariant Apache-2.0 (permissive) · 068dc7002d3e96a4 · report fixture: signature s_sc:Tensor/2/float, s_sa:Tensor/2/float, s_wn:Tensor/2/float, s_wc:Tensor/2/float, s_wo:Tensor/3/float, s_wv:Tensor/4/float, g_sc:list/1/int, g_sa:list/1/int, g_wn:list/1/int, g_wc:list/1/list, g_wo:list/1/list, g_wvi:list/1/list · returned Tensor · level recorded 2026-09-22
TooTouch/SPARTA community (archive-listed) 8 samples, 0 ran · 8 unverified
SAP SQLova/sqlova/model/nl2sql/wikisql_models.py unverified no licence file found · pointer only · cdf03242032636be · report
SCP SQLova/sqlova/model/nl2sql/wikisql_models.py unverified no licence file found · pointer only · a763d4e5c8fee70a · report
Seq2SQL_v1 SQLova/sqlova/model/nl2sql/wikisql_models.py unverified no licence file found · pointer only · 6fa2b6ffbbd7a34d · report
WCP SQLova/sqlova/model/nl2sql/wikisql_models.py unverified no licence file found · pointer only · 3445c5709b9efe59 · report
WNP SQLova/sqlova/model/nl2sql/wikisql_models.py unverified no licence file found · pointer only · 13d3b06dde73507c · report
WOP SQLova/sqlova/model/nl2sql/wikisql_models.py unverified no licence file found · pointer only · 6afa611f06e6153d · report
WVP_se SQLova/sqlova/model/nl2sql/wikisql_models.py unverified no licence file found · pointer only · 8a301f33757b7b7d · report
topk_multi_dim SQLova/sqlova/model/nl2sql/wikisql_models.py unverified no licence file found · pointer only · 747aeef5152d47f3 · report
qjay612/meta_learning_NL2SQL community (archive-listed) 22 samples, 15 ran (13 instrument-failed) · 7 unverified
LSTM in 9 papers src/models/model_wikisql.py ran no licence file found · pointer only · ac5d84fb34186021 · report fixture: returned LSTM · level recorded 2026-09-22
build_mask src/models/model_wikisql.py ran · our draft was wrong no licence file found · pointer only · 5d0aa1b1e4f523a2 · report fixture: signature seq:Tensor/3/float, seq_lens:list/1/int, dim:int/0/int · returned Tensor · level recorded 2026-09-22
check_sc_sa_pairs src/models/model_wikisql.py ran; the contract check could not run (RAISES) no licence file found · pointer only · d4e958304e9d9cd3 · report fixture: signature tb:list/1/dict, pr_sc:list/1/int, pr_sa:list/1/int · returned list · level recorded 2026-09-22
convert_val_index_wp_to_string src/models/model_wikisql.py ran · our draft was wrong no licence file found · pointer only · ae7374b246065c73 · report fixture: signature wp_to_cn_index:list/1/list, val_index_wp:list/1/list, q_tok_cn:list/1/list, q_tok_wp:list/1/list, ad_hoc:bool/0/bool · returned tuple · level recorded 2026-09-22
encode_header src/models/model_wikisql.py ran · our draft was wrong no licence file found · pointer only · 5d61fcf60d724be7 · report fixture: signature encoder:callable/0/?, h_emb:Tensor/3/float, h_lens:Tensor/1/int, h_nums:list/1/int, pooling_type:str/0/str, init_states:NoneType/0/? · returned Tensor · level recorded 2026-09-22
encode_question src/models/model_wikisql.py ran · our draft was wrong no licence file found · pointer only · 5bdce29c753f1649 · report fixture: signature encoder:callable/0/?, q_emb:Tensor/3/float, lens:Tensor/1/int, init_states:tuple/1/Tensor · returned Tensor · level recorded 2026-09-22
merge_val_to_english src/models/model_wikisql.py ran · our draft was wrong no licence file found · pointer only · 57026522c11734ff · report fixture: signature where_str_tokens:list/1/str, NLq:str/0/str · returned str · level recorded 2026-09-22
pooling in 13 papers src/models/model_wikisql.py ran; the contract check could not run (RAISES) no licence file found · pointer only · eb5186ba7911c429 · report fixture: signature emb:Tensor/3/float, lens:list/1/int, type:str/0/str · returned Tensor · level recorded 2026-09-22
pred_sel_col_for_beam src/models/model_wikisql.py ran · our draft was wrong no licence file found · pointer only · 2f695c2ab714eb6a · report fixture: signature score_sel_col:list/1/Tensor, beam_size:int/0/int · returned list · level recorded 2026-09-22
pred_where_col src/models/model_wikisql.py ran · our draft was wrong no licence file found · pointer only · 65e08da52bb4da90 · report fixture: signature now_where_num:list/1/int, score_where_col:list/1/Tensor · returned list · level recorded 2026-09-22
pred_where_num src/models/model_wikisql.py ran · honoured contract no licence file found · pointer only · 0f10e61b084db2c9 · report fixture: signature score_where_num:list/1/Tensor · returned list · level recorded 2026-09-22
pred_where_op src/models/model_wikisql.py ran; the contract check could not run (RAISES) fingerprinted no licence file found · pointer only · 7a5f57930ec795b6 · report fixture: signature now_where_num:list/1/int, score_where_op:list/1/list · returned list · level recorded 2026-09-22
pred_where_val_beam src/models/model_wikisql.py ran · our draft was wrong fingerprinted no licence file found · pointer only · 3a8f7933be76eb6b · report fixture: signature max_wn:int/0/int, s_wv:Tensor/4/float, beam_size:int/0/int · returned tuple · level recorded 2026-09-22
remap_sc_idx src/models/model_wikisql.py ran; the contract check could not run (RAISES) no licence file found · pointer only · c98ecfdf5528adb3 · report fixture: signature idxs:list/1/list, pr_sc_beam:list/1/list · returned list · level recorded 2026-09-22
topk_multi_dim src/models/model_wikisql.py ran; the contract check could not run (RAISES) fingerprinted no licence file found · pointer only · 73606ccc893d7732 · report fixture: signature tensor:Tensor/3/float, n_topk:int/0/int, batch_exist:bool/0/bool · returned list · level recorded 2026-09-22
SelectAggregation src/models/model_wikisql.py unverified no licence file found · pointer only · 2f6b1d0d0eddc156 · report
SelectColumn src/models/model_wikisql.py unverified no licence file found · pointer only · d32f9af1a31a554c · report
Seq2SQL src/models/model_wikisql.py unverified no licence file found · pointer only · a2b9129ba9fabf46 · report
WhereColumn src/models/model_wikisql.py unverified no licence file found · pointer only · 599d8d43c163313c · report
WhereNumber src/models/model_wikisql.py unverified no licence file found · pointer only · a8c231a782002eb4 · report
WhereOperator src/models/model_wikisql.py unverified no licence file found · pointer only · 866f4764788d2be3 · report
WhereValue src/models/model_wikisql.py unverified no licence file found · pointer only · f86a9d196e17299e · report
tanmay1618/text_to_sql_bert community (archive-listed) 2 samples, 2 ran (1 instrument-failed) · 0 unverified
gelu in 308 papers
census: 43 implementations from 74 papers, 6 distinct outputs on one shared input this sample: bucket 1 of 1, arg 1: rank 2, kind float, dtype float32
modeling_bert.py ran · honoured contract fingerprinted no licence file found · pointer only · fdc64f4c72036ae4 · report fixture: signature x:Tensor/2/float · returned Tensor · level recorded 2026-09-22
load_tf_weights_in_bert in 135 papers modeling_bert.py ran · our draft was wrong no licence file found · pointer only · 0c145728a35789fa · report fixture: signature model:callable/0/?, config:Config/0/?, tf_checkpoint_path:str/0/str · returned BertModel · level recorded 2026-09-22
Repository not located 1 sample, 1 ran (1 instrument-failed) · 0 unverified
1 sample is identical to code Syntology harvested from another paper's repository; this paper's own copy was not located, so no repository is named and no licence is recorded.
swish in 258 papers
census: 14 implementations from 37 papers, 2 distinct outputs on one shared input this sample: bucket 1 of 1, arg 1: rank 2, kind float, dtype float32
repository not located ran · our draft was wrong fingerprinted licence of this copy not recorded · 0f786c407fb1ee4c · report fixture: signature x:Tensor/2/float · returned Tensor · level recorded, date not recorded

Method as code Syntology

What Syntology's graph records as this paper's claimed method, lifted into code: each assembly names its bricks (functions and classes), each with its own role and its own verification level. An assembly is not a check that the code implements the method correctly or reproduces the paper's results. Levels are each brick's own verification level in Syntology's graph (level 0: no recorded run), listed brick by brick and never combined into one level; “ran” means the brick executed on a synthesized input, not that its output is correct, and the instrument figure counts failures of Syntology's instrument, not of the code. Where a model read the code against the paper's claim, each assembly's label verdict is one model's judgement, kept in this page's JSON twin; it is not calibrated, so no card prints it. Siblings are assemblies lifted from this paper in the same batch for the same method: alternative readings kept side by side; none replaces or supersedes another.

2 assemblies on this paper: 2 harvested, 0 generated, listed in 1 groups (siblings lifted in one batch form one group).

2 sibling assemblies for SQLova (harvested), lifted in the same batch on 2026-09-09: alternative readings kept side by side; none replaces or supersedes another.

harvested Assembly for SQLova (graph method: SQLova). 22 bricks; individually on a fixture: 15 ran (of which 1 constructed an object rather than computing a result; 2 with no instrument failure: 1 honoured, 0 violated, 1 with no contract checked; 13 where Syntology's instrument failed) · 7 unverified. The assembly has not been run end-to-end.

one of 2 siblings

  1. Seq2SQL entry · level 0 · unverified · a2b9129ba9fabf46
  2. SelectAggregation model · level 0 · unverified · 2f6b1d0d0eddc156
  3. SelectColumn model · level 0 · unverified · d32f9af1a31a554c
  4. WhereColumn model · level 0 · unverified · 599d8d43c163313c
  5. WhereNumber model · level 0 · unverified · a8c231a782002eb4
  6. WhereOperator model · level 0 · unverified · 866f4764788d2be3
  7. WhereValue model · level 0 · unverified · f86a9d196e17299e
  8. check_sc_sa_pairs helper · level 1 · ran; the contract check could not run (RAISES) · d4e958304e9d9cd3
  9. convert_val_index_wp_to_string helper · level 1 · ran · our draft was wrong · ae7374b246065c73
  10. merge_val_to_english helper · level 1 · ran · our draft was wrong · 57026522c11734ff
  11. pred_sel_col_for_beam helper · level 1 · ran · our draft was wrong · 2f695c2ab714eb6a
  12. pred_where_col helper · level 1 · ran · our draft was wrong · 65e08da52bb4da90
  13. pred_where_num helper · level 1 · ran · honoured contract · 0f10e61b084db2c9
  14. pred_where_op helper · level 1 · ran; the contract check could not run (RAISES) · 7a5f57930ec795b6
  15. pred_where_val_beam helper · level 1 · ran · our draft was wrong · 3a8f7933be76eb6b
  16. remap_sc_idx helper · level 1 · ran; the contract check could not run (RAISES) · c98ecfdf5528adb3
  17. topk_multi_dim helper · level 1 · ran; the contract check could not run (RAISES) · 73606ccc893d7732
  18. LSTM model · level 1 · ran · ac5d84fb34186021
  19. build_mask helper · level 1 · ran · our draft was wrong · 5d0aa1b1e4f523a2
  20. encode_header helper · level 1 · ran · our draft was wrong · 5d61fcf60d724be7
  21. encode_question helper · level 1 · ran · our draft was wrong · 5bdce29c753f1649
  22. pooling helper · level 1 · ran; the contract check could not run (RAISES) · eb5186ba7911c429

harvested Assembly for SQLova (graph method: SQLova). 8 bricks; individually on a fixture: 0 ran · 8 unverified. The assembly has not been run end-to-end.

one of 2 siblings

  1. Seq2SQL_v1 entry · level 0 · unverified · 6fa2b6ffbbd7a34d
  2. SAP model · level 0 · unverified · cdf03242032636be
  3. SCP model · level 0 · unverified · a763d4e5c8fee70a
  4. WCP model · level 0 · unverified · 3445c5709b9efe59
  5. WNP model · level 0 · unverified · 13d3b06dde73507c
  6. WOP model · level 0 · unverified · 6afa611f06e6153d
  7. WVP_se model · level 0 · unverified · 8a301f33757b7b7d
  8. topk_multi_dim helper · level 0 · unverified · 747aeef5152d47f3

Each brick ends with its code_sha256, Syntology's identity for that exact code; click one to copy the get_code call that returns it. For agents, on Syntology's MCP service: assembly(arxiv_id="1902.01069") returns these assemblies with each brick's role and wiring (how to connect).

Tasks

DecoderSemantic Parsing

Results from the paper archive 2025-07-28

No leaderboard rows for this paper in the archive.

Methods

AdamAttentionAttention DropoutBERTDense ConnectionsDropoutLSTMLayer NormalizationLinear LayerLinear Warmup With Linear DecayMulti-Head AttentionResidual ConnectionSeq2SeqSigmoid ActivationSoftmaxTanh ActivationWeight DecayWordPiece

Report a problem or propose a change · a person checks every report against the paper or source before anything changes; decisions are listed on /corrections