{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,8]],"date-time":"2026-05-08T16:46:16Z","timestamp":1778258776334,"version":"3.51.4"},"reference-count":132,"publisher":"Institute of Electrical and Electronics Engineers (IEEE)","issue":"11","license":[{"start":{"date-parts":[[2024,11,1]],"date-time":"2024-11-01T00:00:00Z","timestamp":1730419200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/ieeexplore.ieee.org\/Xplorehelp\/downloads\/license-information\/IEEE.html"},{"start":{"date-parts":[[2024,11,1]],"date-time":"2024-11-01T00:00:00Z","timestamp":1730419200000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-029"},{"start":{"date-parts":[[2024,11,1]],"date-time":"2024-11-01T00:00:00Z","timestamp":1730419200000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-037"}],"funder":[{"name":"HKUST-WeBank Joint Laboratory Project","award":["HWJL-2023.003"],"award-info":[{"award-number":["HWJL-2023.003"]}]},{"name":"HKUST-WeBank Joint Laboratory Project","award":["WEB24EG01-A"],"award-info":[{"award-number":["WEB24EG01-A"]}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["IEEE Trans. Knowl. Data Eng."],"published-print":{"date-parts":[[2024,11]]},"DOI":"10.1109\/tkde.2024.3400824","type":"journal-article","created":{"date-parts":[[2024,5,14]],"date-time":"2024-05-14T17:37:19Z","timestamp":1715708239000},"page":"6699-6718","source":"Crossref","is-referenced-by-count":30,"title":["Natural Language Interfaces for Tabular Data Querying and Visualization: A Survey"],"prefix":"10.1109","volume":"36","author":[{"ORCID":"https:\/\/orcid.org\/0009-0003-2000-7891","authenticated-orcid":false,"given":"Weixu","family":"Zhang","sequence":"first","affiliation":[{"name":"Xi'an Jiaotong University, Xi'an, Shaanxi, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0009-1890-9232","authenticated-orcid":false,"given":"Yifei","family":"Wang","sequence":"additional","affiliation":[{"name":"University of Toronto, Toronto, ON, Canada"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-2221-9807","authenticated-orcid":false,"given":"Yuanfeng","family":"Song","sequence":"additional","affiliation":[{"name":"WeBank Company Ltd., Shenzhen, Guangdong, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-5548-7301","authenticated-orcid":false,"given":"Victor Junqiu","family":"Wei","sequence":"additional","affiliation":[{"name":"Department of Computer Science and Engineering, Hong Kong University of Science and Technology (HKUST), Hong Kong"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0008-0313-5089","authenticated-orcid":false,"given":"Yuxing","family":"Tian","sequence":"additional","affiliation":[{"name":"Xidian University, Xi'an, Shaanxi, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-8078-5834","authenticated-orcid":false,"given":"Yiyan","family":"Qi","sequence":"additional","affiliation":[{"name":"IDEA, Shenzhen, Guangdong, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-2384-0462","authenticated-orcid":false,"given":"Jonathan H.","family":"Chan","sequence":"additional","affiliation":[{"name":"Innovative Cognitive Computing (IC2) Research Center, School of Information Technology, King Mongkut's University of Technology Thonburi, Bangkok, Thailand"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-7045-6503","authenticated-orcid":false,"given":"Raymond Chi-Wing","family":"Wong","sequence":"additional","affiliation":[{"name":"Department of Computer Science and Engineering, Hong Kong University of Science and Technology (HKUST), Hong Kong"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-5453-476X","authenticated-orcid":false,"given":"Haiqin","family":"Yang","sequence":"additional","affiliation":[{"name":"IDEA, Shenzhen, Guangdong, China"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"263","reference":[{"key":"ref1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-019-00567-8"},{"key":"ref2","doi-asserted-by":"publisher","DOI":"10.1017\/S135132490000005X"},{"key":"ref3","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2019.00041"},{"key":"ref4","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/P19-1448"},{"key":"ref5","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/D19-1378"},{"key":"ref6","first-page":"7664","article-title":"SADGA: Structure-aware dual graph aggregation network for Text-to-SQL","volume-title":"Proc. Adv. Neural Inf. Process. Syst.","author":"Cai"},{"key":"ref7","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2021.acl-long.198"},{"key":"ref8","article-title":"Dr. Spider: A diagnostic evaluation benchmark towards Text-to-SQL robustness","volume-title":"Proc. Int. Conf. Learn. Representations","author":"Chang"},{"key":"ref9","article-title":"Evaluating large language models trained on code","author":"Chen","year":"2021"},{"key":"ref10","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526166"},{"key":"ref11","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2021.naacl-main.441"},{"key":"ref12","doi-asserted-by":"publisher","DOI":"10.1162\/coli_a_00403"},{"key":"ref13","doi-asserted-by":"publisher","DOI":"10.3115\/1075812.1075823"},{"key":"ref14","first-page":"2166","article-title":"Recent advances in Text-to-SQL: A survey of what we have and what we expect","volume-title":"Proc. Int. Conf. Comput. Linguistics","author":"Deng"},{"key":"ref15","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2021.naacl-main.105"},{"key":"ref16","doi-asserted-by":"publisher","DOI":"10.48550\/arXiv.1810.04805"},{"key":"ref17","doi-asserted-by":"publisher","DOI":"10.1109\/MCG.2019.2924636"},{"key":"ref18","doi-asserted-by":"publisher","DOI":"10.3115\/1289189.1289273"},{"key":"ref19","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/P16-1004"},{"key":"ref20","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/P18-1068"},{"key":"ref21","article-title":"A survey on in-context learning","author":"Dong","year":"2023","journal-title":"arXiv:2301.00234"},{"key":"ref22","article-title":"C3: Zero-shot Text-to-SQL with chatgpt","author":"Dong","year":"2023"},{"key":"ref23","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2022.emnlp-main.350"},{"key":"ref24","doi-asserted-by":"publisher","DOI":"10.1007\/s13042-023-01898-3"},{"key":"ref25","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/P18-1033"},{"key":"ref26","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2022.findings-naacl.62"},{"key":"ref27","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2021.acl-long.195"},{"key":"ref28","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2021.emnlp-main.702"},{"key":"ref29","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2021.findings-emnlp.174"},{"key":"ref30","doi-asserted-by":"publisher","DOI":"10.1145\/2807442.2807478"},{"key":"ref31","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3452836"},{"key":"ref32","doi-asserted-by":"publisher","DOI":"10.3115\/974194.974201"},{"key":"ref33","doi-asserted-by":"publisher","DOI":"10.1145\/3589292"},{"key":"ref34","article-title":"Interleaving pre-trained language models and large language models for zero-shot NL2SQL generation","author":"Gu","year":"2023"},{"key":"ref35","doi-asserted-by":"publisher","DOI":"10.1007\/978-981-99-8076-5_25"},{"key":"ref36","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2021.findings-emnlp.222"},{"key":"ref37","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2021.acl-long.180"},{"key":"ref38","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/P19-1444"},{"key":"ref39","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2021.nlp4prog-1.9"},{"key":"ref40","article-title":"X-SQL: Reinforce schema representation with context","author":"He","year":"2019"},{"key":"ref41","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2017.2744684"},{"key":"ref42","article-title":"LoRA: Low-rank adaptation of large language models","volume-title":"Proc. Int. Conf. Learn. Representations","author":"Hu"},{"key":"ref43","doi-asserted-by":"publisher","DOI":"10.1609\/aaai.v35i14.17550"},{"key":"ref44","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2022.findings-acl.99"},{"key":"ref45","article-title":"A comprehensive exploration on WikiSQL with table-aware word contextualization","author":"Hwang","year":"2019"},{"key":"ref46","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2020.coling-main.34"},{"key":"ref47","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/P17-1089"},{"key":"ref48","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-030-91699-2_35"},{"key":"ref49","article-title":"A survey on semantic parsing","volume-title":"Proc. Conf. Automated Knowl. Base Construction","author":"Kamath"},{"key":"ref50","doi-asserted-by":"publisher","DOI":"10.1145\/3170427.3188445"},{"key":"ref51","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3457543"},{"key":"ref52","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-022-00776-8"},{"key":"ref53","doi-asserted-by":"publisher","DOI":"10.14778\/3401960.3401970"},{"key":"ref54","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/W16-3639"},{"key":"ref55","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2020.acl-main.703"},{"key":"ref56","doi-asserted-by":"publisher","DOI":"10.14778\/2735461.2735468"},{"key":"ref57","doi-asserted-by":"publisher","DOI":"10.1609\/aaai.v37i11.26535"},{"key":"ref58","doi-asserted-by":"publisher","DOI":"10.1609\/aaai.v37i11.26536"},{"key":"ref59","article-title":"Can LLM already serve as A database interface? A big bench for large-scale database grounded Text-to-SQLs","author":"Li","year":"2023"},{"key":"ref60","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2020.findings-emnlp.438"},{"key":"ref61","article-title":"NL2Bash: A corpus and semantic parser for natural language interface to the Linux operating system","volume-title":"Proc. 11th Int. Conf. Lang. Resour. Eval.","author":"Lin"},{"key":"ref62","article-title":"A comprehensive evaluation of ChatGPTs zero-shot Text-to-SQL capability","author":"Liu","year":"2023"},{"key":"ref63","doi-asserted-by":"publisher","DOI":"10.1109\/PacificVis52677.2021.00010"},{"key":"ref64","article-title":"Divide and prompt: Chain of thought prompting for Text-to-SQL","author":"Liu","year":"2023"},{"key":"ref65","article-title":"RoBERTa: A robustly optimized BERT pretraining approach","author":"Liu","year":"2019"},{"key":"ref66","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415489"},{"key":"ref67","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3193545"},{"key":"ref68","article-title":"nvBench: A large-scale synthesized dataset for cross-domain natural language to visualization task","author":"Luo","year":"2021"},{"key":"ref69","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3457261"},{"key":"ref70","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2021.3114848"},{"key":"ref71","article-title":"Hybrid ranking network for Text-to-SQL","author":"Lyu","year":"2020"},{"key":"ref72","doi-asserted-by":"publisher","DOI":"10.1109\/ACCESS.2023.3274199"},{"key":"ref73","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/D19-1377"},{"key":"ref74","doi-asserted-by":"publisher","DOI":"10.1109\/VIS54862.2022.00010"},{"key":"ref75","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2023.findings-emnlp.996"},{"key":"ref76","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2020.3030378"},{"key":"ref77","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2020.findings-emnlp.364"},{"key":"ref78","article-title":"Bidirectional language models are also few-shot learners","volume-title":"Proc. Int. Conf. Learn. Representations","author":"Patel"},{"key":"ref79","doi-asserted-by":"publisher","DOI":"10.3115\/1220355.1220376"},{"key":"ref80","doi-asserted-by":"publisher","DOI":"10.1145\/604045.604070"},{"key":"ref81","article-title":"DIN-SQL: Decomposed in-context learning of Text-to-SQL with self-correction","volume-title":"Proc. Adv. Neural Inf. Process. Syst.","volume":"36","author":"Pourreza"},{"key":"ref82","doi-asserted-by":"publisher","DOI":"10.3115\/116580.116612"},{"key":"ref83","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-019-00588-3"},{"key":"ref84","first-page":"140:1","article-title":"Exploring the limits of transfer learning with a unified text-to-text transformer","volume":"21","author":"Raffel","year":"2020","journal-title":"J. Mach. Learn. Res."},{"key":"ref85","article-title":"Evaluating the Text-to-SQL capabilities of large language models","author":"Rajkumar","year":"2022"},{"key":"ref86","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2021.naacl-main.29"},{"key":"ref87","doi-asserted-by":"publisher","DOI":"10.14778\/2994509.2994536"},{"key":"ref88","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2021.emnlp-main.779"},{"key":"ref89","doi-asserted-by":"publisher","DOI":"10.1145\/2984511.2984588"},{"key":"ref90","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2020.acl-main.328"},{"key":"ref91","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2021.acl-long.75"},{"key":"ref92","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2022.3148007"},{"key":"ref93","doi-asserted-by":"publisher","DOI":"10.1609\/aaai.v35i15.17627"},{"key":"ref94","article-title":"IncSQL: Training incremental Text-to-SQL parsers with non-deterministic oracles","author":"Shi","year":"2018"},{"key":"ref95","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3520158"},{"key":"ref96","doi-asserted-by":"publisher","DOI":"10.1145\/3637528.3671935"},{"key":"ref97","doi-asserted-by":"publisher","DOI":"10.1145\/3534678.3539330"},{"key":"ref98","doi-asserted-by":"publisher","DOI":"10.1145\/3313831.3376782"},{"key":"ref99","doi-asserted-by":"publisher","DOI":"10.1145\/3411764.3445400"},{"key":"ref100","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2017.2745219"},{"key":"ref101","doi-asserted-by":"publisher","DOI":"10.1109\/IV56949.2022.00031"},{"key":"ref102","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2020.acl-main.742"},{"key":"ref103","article-title":"TableQA: A large-scale chinese Text-to-SQL dataset for table-aware SQL generation","author":"Sun","year":"2020"},{"key":"ref104","article-title":"SQL-PaLM: Improved large language model adaptation for Text-to-SQL","author":"Sun","year":"2023"},{"key":"ref105","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2023.emnlp-main.327"},{"key":"ref106","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3520150"},{"key":"ref107","doi-asserted-by":"publisher","DOI":"10.3115\/1117794.1117811"},{"key":"ref108","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2020.acl-main.677"},{"key":"ref109","article-title":"Execution-guided neural program decoding","author":"Wang","year":"2018"},{"key":"ref110","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2020.emnlp-main.562"},{"key":"ref111","doi-asserted-by":"publisher","DOI":"10.1145\/3366423.3380120"},{"issue":"3-4","key":"ref112","first-page":"110","article-title":"An efficient easily adaptable system for interpreting natural language queries","volume":"8","author":"Warren","year":"1982","journal-title":"Am. J. Comput. Linguistics"},{"key":"ref113","article-title":"Emergent abilities of large language models","author":"Wei","year":"2022","journal-title":"Trans. Mach. Learn. Res."},{"key":"ref114","first-page":"24824","article-title":"Chain-of-thought prompting elicits reasoning in large language models","volume-title":"Proc. Adv. Neural Inf. Process. Syst.","author":"Wei"},{"key":"ref115","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2022.emnlp-main.39"},{"key":"ref116","article-title":"SQLNet: Generating structured queries from natural language without reinforcement learning","author":"Xu","year":"2017"},{"key":"ref117","doi-asserted-by":"publisher","DOI":"10.1145\/3133887"},{"key":"ref118","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/P17-1041"},{"key":"ref119","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2020.acl-main.745"},{"key":"ref120","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2016.2598497"},{"key":"ref121","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2019.2934668"},{"key":"ref122","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/N18-2093"},{"key":"ref123","article-title":"GraPPa: Grammar-augmented pre-training for table semantic parsing","volume-title":"Proc. Int. Conf. Learn. Representations","author":"Yu"},{"key":"ref124","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/D18-1193"},{"key":"ref125","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/D19-1204"},{"key":"ref126","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/D18-1425"},{"key":"ref127","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/P19-1443"},{"key":"ref128","first-page":"1050","article-title":"Learning to parse database queries using inductive logic programming","volume-title":"Proc. Conf. Assoc. Advance. Artif. Intell.","author":"Zelle"},{"key":"ref129","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2020.acl-demos.24"},{"key":"ref130","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/D19-1537"},{"key":"ref131","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2020.emnlp-main.29"},{"key":"ref132","article-title":"Seq2SQL: Generating structured queries from natural language using reinforcement learning","author":"Zhong","year":"2017"}],"container-title":["IEEE Transactions on Knowledge and Data Engineering"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx7\/69\/10709365\/10530359.pdf?arnumber=10530359","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,10,9]],"date-time":"2024-10-09T05:41:12Z","timestamp":1728452472000},"score":1,"resource":{"primary":{"URL":"https:\/\/ieeexplore.ieee.org\/document\/10530359\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,11]]},"references-count":132,"journal-issue":{"issue":"11"},"URL":"https:\/\/doi.org\/10.1109\/tkde.2024.3400824","relation":{},"ISSN":["1041-4347","1558-2191","2326-3865"],"issn-type":[{"value":"1041-4347","type":"print"},{"value":"1558-2191","type":"electronic"},{"value":"2326-3865","type":"electronic"}],"subject":[],"published":{"date-parts":[[2024,11]]}}}