{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,8]],"date-time":"2026-04-08T08:54:18Z","timestamp":1775638458445,"version":"3.50.1"},"reference-count":58,"publisher":"Association for Computing Machinery (ACM)","issue":"6","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2023,2]]},"abstract":"<jats:p>\n            Natural language to SQL (NL2SQL) techniques provide a convenient interface to access databases, especially for non-expert users, to conduct various data analytics. Existing methods often employ either a rule-base approach or a deep learning based solution. The former is hard to generalize across different domains. Though the latter generalizes well, it often results in queries with syntactic or semantic errors, thus may be even not executable. In this work, we bridge the gap between the two and design a new framework to significantly improve both accuracy and runtime. In particular, we develop a novel\n            <jats:italic>CatSQL<\/jats:italic>\n            sketch, which constructs a template with slots that initially serve as placeholders, and tightly integrates with a deep learning model to fill in these slots with meaningful contents based on the database schema. Compared with the widely used sequence-to-sequence-based approaches, our sketch-based method does not need to generate keywords which are boilerplates in the template, and can achieve better accuracy and run much faster. Compared with the existing sketch-based approaches, our\n            <jats:italic>CatSQL<\/jats:italic>\n            sketch is more general and versatile, and can leverage the values already filled in on certain slots to derive the rest ones for improved performance. In addition, we propose the\n            <jats:italic>Semantics Correction<\/jats:italic>\n            technique, which is the first that leverages database domain knowledge in a deep learning based NL2SQL solution.\n            <jats:italic>Semantics Correction<\/jats:italic>\n            is a post-processing routine, which checks the initially generated SQL queries by applying rules to identify and correct semantic errors. This technique significantly improves the NL2SQL accuracy. We conduct extensive evaluations on both single-domain and cross-domain benchmarks and demonstrate that our approach significantly outperforms the previous ones in terms of both accuracy and throughput. In particular, on the state-of-the-art NL2SQL benchmark Spider, our\n            <jats:italic>CatSQL<\/jats:italic>\n            prototype outperforms the best of the previous solutions by 4 points on accuracy, while still achieving a throughput up to 63 times higher.\n          <\/jats:p>","DOI":"10.14778\/3583140.3583165","type":"journal-article","created":{"date-parts":[[2023,4,20]],"date-time":"2023-04-20T16:45:59Z","timestamp":1682009159000},"page":"1534-1547","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":46,"title":["<i>CatSQL<\/i>\n            : Towards Real World Natural Language to SQL Applications"],"prefix":"10.14778","volume":"16","author":[{"given":"Han","family":"Fu","sequence":"first","affiliation":[{"name":"Alibaba Group"}]},{"given":"Chang","family":"Liu","sequence":"additional","affiliation":[{"name":"Alibaba Group"}]},{"given":"Bin","family":"Wu","sequence":"additional","affiliation":[{"name":"Alibaba Group"}]},{"given":"Feifei","family":"Li","sequence":"additional","affiliation":[{"name":"Alibaba Group"}]},{"given":"Jian","family":"Tan","sequence":"additional","affiliation":[{"name":"Alibaba Group"}]},{"given":"Jianling","family":"Sun","sequence":"additional","affiliation":[{"name":"Zhejiang University"}]}],"member":"320","published-online":{"date-parts":[[2023,4,20]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"Neural machine translation by jointly learning to align and translate. arXiv preprint","author":"Bahdanau Dzmitry","year":"2014","unstructured":"Dzmitry Bahdanau , Kyunghyun Cho , and Yoshua Bengio . 2014. Neural machine translation by jointly learning to align and translate. arXiv preprint ( 2014 ). Dzmitry Bahdanau, Kyunghyun Cho, and Yoshua Bengio. 2014. Neural machine translation by jointly learning to align and translate. arXiv preprint (2014)."},{"key":"e_1_2_1_2_1","unstructured":"Christopher Baik HV Jagadish and Yunyao Li. 2019. Bridging the Semantic Gap with SQL Query Logs in Natural Language Interfaces to Databases. In ICDE.  Christopher Baik HV Jagadish and Yunyao Li. 2019. Bridging the Semantic Gap with SQL Query Logs in Natural Language Interfaces to Databases. In ICDE."},{"key":"e_1_2_1_3_1","doi-asserted-by":"crossref","unstructured":"Fuat Basik Benjamin H\u00e4ttasch Amir Ilkhechi Arif Usta Shekar Ramaswamy Prasetya Utama Nathaniel Weir Carsten Binnig and Ugur Cetintemel. 2018. DBPal: A Learned NL-Interface for Databases. In SIGMOD.  Fuat Basik Benjamin H\u00e4ttasch Amir Ilkhechi Arif Usta Shekar Ramaswamy Prasetya Utama Nathaniel Weir Carsten Binnig and Ugur Cetintemel. 2018. DBPal: A Learned NL-Interface for Databases. In SIGMOD.","DOI":"10.1145\/3183713.3193562"},{"key":"e_1_2_1_4_1","doi-asserted-by":"crossref","unstructured":"Hannah Bast and Elmar Haussmann. 2015. More accurate question answering on freebase. In CIKM.  Hannah Bast and Elmar Haussmann. 2015. More accurate question answering on freebase. In CIKM.","DOI":"10.1145\/2806416.2806472"},{"key":"e_1_2_1_5_1","doi-asserted-by":"crossref","unstructured":"Sonia Bergamaschi Francesco Guerra Matteo Interlandi Raquel Trillo-Lado and Yannis Velegrakis. 2013. QUEST: a keyword search system for relational data based on semantic and machine learning techniques.  Sonia Bergamaschi Francesco Guerra Matteo Interlandi Raquel Trillo-Lado and Yannis Velegrakis. 2013. QUEST: a keyword search system for relational data based on semantic and machine learning techniques.","DOI":"10.14778\/2536274.2536281"},{"key":"e_1_2_1_6_1","volume-title":"Proceedings of the 57th Annual Meeting of the Association for Computational Linguistics. 4560--4565","author":"Bogin Ben","year":"2019","unstructured":"Ben Bogin , Jonathan Berant , and Matt Gardner . 2019 . Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsing . In Proceedings of the 57th Annual Meeting of the Association for Computational Linguistics. 4560--4565 . Ben Bogin, Jonathan Berant, and Matt Gardner. 2019. Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsing. In Proceedings of the 57th Annual Meeting of the Association for Computational Linguistics. 4560--4565."},{"key":"e_1_2_1_7_1","volume-title":"Proceedings of COMPSTAT'2010","author":"Bottou L\u00e9on","year":"2010","unstructured":"L\u00e9on Bottou . 2010 . Large-scale machine learning with stochastic gradient descent . In Proceedings of COMPSTAT'2010 . Springer, 177--186. L\u00e9on Bottou. 2010. Large-scale machine learning with stochastic gradient descent. In Proceedings of COMPSTAT'2010. Springer, 177--186."},{"key":"e_1_2_1_8_1","volume-title":"Proceedings of the 59th Annual Meeting of the Association for Computational Linguistics and the 11th International Joint Conference on Natural Language Processing (Volume 1: Long Papers). 2541--2555","author":"Cao Ruisheng","year":"2021","unstructured":"Ruisheng Cao , Lu Chen , Zhi Chen , Yanbin Zhao , Su Zhu , and Kai Yu . 2021 . LGESQL: Line Graph Enhanced Text-to-SQL Model with Mixed Local and Non-Local Relations . In Proceedings of the 59th Annual Meeting of the Association for Computational Linguistics and the 11th International Joint Conference on Natural Language Processing (Volume 1: Long Papers). 2541--2555 . Ruisheng Cao, Lu Chen, Zhi Chen, Yanbin Zhao, Su Zhu, and Kai Yu. 2021. LGESQL: Line Graph Enhanced Text-to-SQL Model with Mixed Local and Non-Local Relations. In Proceedings of the 59th Annual Meeting of the Association for Computational Linguistics and the 11th International Joint Conference on Natural Language Processing (Volume 1: Long Papers). 2541--2555."},{"key":"e_1_2_1_9_1","first-page":"309","article-title":"Ryansql: Recursively applying sketch-based slot fillings for complex text-to-sql in cross-domain databases","volume":"47","author":"Choi DongHyun","year":"2021","unstructured":"DongHyun Choi , Myeong Cheol Shin , EungGyun Kim , and Dong Ryeol Shin . 2021 . Ryansql: Recursively applying sketch-based slot fillings for complex text-to-sql in cross-domain databases . Computational Linguistics 47 , 2 (2021), 309 -- 332 . DongHyun Choi, Myeong Cheol Shin, EungGyun Kim, and Dong Ryeol Shin. 2021. Ryansql: Recursively applying sketch-based slot fillings for complex text-to-sql in cross-domain databases. Computational Linguistics 47, 2 (2021), 309--332.","journal-title":"Computational Linguistics"},{"key":"e_1_2_1_10_1","volume-title":"International Conference on Learning Representations.","author":"Clark Kevin","year":"2019","unstructured":"Kevin Clark , Minh-Thang Luong , Quoc V Le , and Christopher D Manning . 2019 . ELECTRA: Pre-training Text Encoders as Discriminators Rather Than Generators . In International Conference on Learning Representations. Kevin Clark, Minh-Thang Luong, Quoc V Le, and Christopher D Manning. 2019. ELECTRA: Pre-training Text Encoders as Discriminators Rather Than Generators. In International Conference on Learning Representations."},{"key":"e_1_2_1_11_1","volume-title":"BERT: Pre-training of Deep Bidirectional Transformers for Language Understanding. In NAACL.","author":"Devlin Jacob","year":"2019","unstructured":"Jacob Devlin , Ming-Wei Chang , Kenton Lee , and Kristina Toutanova . 2019 . BERT: Pre-training of Deep Bidirectional Transformers for Language Understanding. In NAACL. Jacob Devlin, Ming-Wei Chang, Kenton Lee, and Kristina Toutanova. 2019. BERT: Pre-training of Deep Bidirectional Transformers for Language Understanding. In NAACL."},{"key":"e_1_2_1_12_1","doi-asserted-by":"crossref","unstructured":"Li Dong and Mirella Lapata. 2016. Language to Logical Form with Neural Attention. In ACL.  Li Dong and Mirella Lapata. 2016. Language to Logical Form with Neural Attention. In ACL.","DOI":"10.18653\/v1\/P16-1004"},{"key":"e_1_2_1_13_1","volume-title":"Findings of the Association for Computational Linguistics: EMNLP 2021. 2030","author":"Gan Yujian","year":"2021","unstructured":"Yujian Gan , Xinyun Chen , Jinxia Xie , Matthew Purver , John R Woodward , John Drake , and Qiaofu Zhang . 2021 . Natural SQL: Making SQL Easier to Infer from Natural Language Specifications . In Findings of the Association for Computational Linguistics: EMNLP 2021. 2030 --2042. Yujian Gan, Xinyun Chen, Jinxia Xie, Matthew Purver, John R Woodward, John Drake, and Qiaofu Zhang. 2021. Natural SQL: Making SQL Easier to Infer from Natural Language Specifications. In Findings of the Association for Computational Linguistics: EMNLP 2021. 2030--2042."},{"key":"e_1_2_1_14_1","doi-asserted-by":"crossref","unstructured":"Bert F Green  Jr Alice K Wolf Carol Chomsky and Kenneth Laughery. 1961. Baseball: an automatic question-answerer. In western joint IRE-AIEE-ACM computer conference.  Bert F Green Jr Alice K Wolf Carol Chomsky and Kenneth Laughery. 1961. Baseball: an automatic question-answerer. In western joint IRE-AIEE-ACM computer conference.","DOI":"10.1145\/1460690.1460714"},{"key":"e_1_2_1_15_1","doi-asserted-by":"crossref","unstructured":"Daya Guo Yibo Sun Duyu Tang Nan Duan Jian Yin Hong Chi James Cao Peng Chen and Ming Zhou. 2018. Question Generation from SQL Queries Improves Neural Semantic Parsing. In EMNLP.  Daya Guo Yibo Sun Duyu Tang Nan Duan Jian Yin Hong Chi James Cao Peng Chen and Ming Zhou. 2018. Question Generation from SQL Queries Improves Neural Semantic Parsing. In EMNLP.","DOI":"10.18653\/v1\/D18-1188"},{"key":"e_1_2_1_16_1","doi-asserted-by":"crossref","unstructured":"Jiaqi Guo Zecheng Zhan Yan Gao Yan Xiao Jian-Guang Lou Ting Liu and Dongmei Zhang. 2019. Towards Complex Text-to-SQL in Cross-Domain Database with Intermediate Representation. In ACL.  Jiaqi Guo Zecheng Zhan Yan Gao Yan Xiao Jian-Guang Lou Ting Liu and Dongmei Zhang. 2019. Towards Complex Text-to-SQL in Cross-Domain Database with Intermediate Representation. In ACL.","DOI":"10.18653\/v1\/P19-1444"},{"key":"e_1_2_1_17_1","volume-title":"X-SQL: reinforce schema representation with context. arXiv preprint","author":"He Pengcheng","year":"2019","unstructured":"Pengcheng He , Yi Mao , Kaushik Chakrabarti , and Weizhu Chen . 2019. X-SQL: reinforce schema representation with context. arXiv preprint ( 2019 ). Pengcheng He, Yi Mao, Kaushik Chakrabarti, and Weizhu Chen. 2019. X-SQL: reinforce schema representation with context. arXiv preprint (2019)."},{"key":"e_1_2_1_18_1","volume-title":"Long short-term memory. Neural computation","author":"Hochreiter Sepp","year":"1997","unstructured":"Sepp Hochreiter and J\u00fcrgen Schmidhuber . 1997. Long short-term memory. Neural computation ( 1997 ). Sepp Hochreiter and J\u00fcrgen Schmidhuber. 1997. Long short-term memory. Neural computation (1997)."},{"key":"e_1_2_1_19_1","volume-title":"Improving text-to-sql with schema dependency learning. arXiv preprint arXiv:2103.04399","author":"Hui Binyuan","year":"2021","unstructured":"Binyuan Hui , Xiang Shi , Ruiying Geng , Binhua Li , Yongbin Li , Jian Sun , and Xiaodan Zhu . 2021. Improving text-to-sql with schema dependency learning. arXiv preprint arXiv:2103.04399 ( 2021 ). Binyuan Hui, Xiang Shi, Ruiying Geng, Binhua Li, Yongbin Li, Jian Sun, and Xiaodan Zhu. 2021. Improving text-to-sql with schema dependency learning. arXiv preprint arXiv:2103.04399 (2021)."},{"key":"e_1_2_1_20_1","volume-title":"A Comprehensive Exploration on WikiSQL with Table-Aware Word Contextualization. arXiv preprint","author":"Hwang Wonseok","year":"2019","unstructured":"Wonseok Hwang , Jinyeung Yim , Seunghyun Park , and Minjoon Seo . 2019. A Comprehensive Exploration on WikiSQL with Table-Aware Word Contextualization. arXiv preprint ( 2019 ). Wonseok Hwang, Jinyeung Yim, Seunghyun Park, and Minjoon Seo. 2019. A Comprehensive Exploration on WikiSQL with Table-Aware Word Contextualization. arXiv preprint (2019)."},{"key":"e_1_2_1_21_1","volume-title":"Proceedings of the 55th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers). 963--973","author":"Iyer Srinivasan","year":"2017","unstructured":"Srinivasan Iyer , Ioannis Konstas , Alvin Cheung , Jayant Krishnamurthy , and Luke Zettlemoyer . 2017 . Learning a Neural Semantic Parser from User Feedback . In Proceedings of the 55th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers). 963--973 . Srinivasan Iyer, Ioannis Konstas, Alvin Cheung, Jayant Krishnamurthy, and Luke Zettlemoyer. 2017. Learning a Neural Semantic Parser from User Feedback. In Proceedings of the 55th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers). 963--973."},{"key":"e_1_2_1_22_1","unstructured":"Saehan Jo Immanuel Trummer Weicheng Yu Xuezhi Wang Cong Yu Daniel Liu and Niyati Mehta. 2019. Verifying text summaries of relational data sets. In SIGMOD.  Saehan Jo Immanuel Trummer Weicheng Yu Xuezhi Wang Cong Yu Daniel Liu and Niyati Mehta. 2019. Verifying text summaries of relational data sets. In SIGMOD."},{"key":"e_1_2_1_23_1","doi-asserted-by":"crossref","first-page":"1737","DOI":"10.14778\/3401960.3401970","article-title":"Natural language to SQL: Where are we today","volume":"13","author":"Kim Hyeonji","year":"2020","unstructured":"Hyeonji Kim , Byeong-Hoon So , Wook-Shin Han , and Hongrae Lee . 2020 . Natural language to SQL: Where are we today ? Proceedings of the VLDB Endowment 13 , 10 (2020), 1737 -- 1750 . Hyeonji Kim, Byeong-Hoon So, Wook-Shin Han, and Hongrae Lee. 2020. Natural language to SQL: Where are we today? Proceedings of the VLDB Endowment 13, 10 (2020), 1737--1750.","journal-title":"Proceedings of the VLDB Endowment"},{"key":"e_1_2_1_24_1","volume-title":"Adam: A method for stochastic optimization. arXiv preprint arXiv:1412.6980","author":"Kingma Diederik P","year":"2014","unstructured":"Diederik P Kingma and Jimmy Ba . 2014 . Adam: A method for stochastic optimization. arXiv preprint arXiv:1412.6980 (2014). Diederik P Kingma and Jimmy Ba. 2014. Adam: A method for stochastic optimization. arXiv preprint arXiv:1412.6980 (2014)."},{"key":"e_1_2_1_25_1","volume-title":"Proceedings of the 58th Annual Meeting of the Association for Computational Linguistics. 7871--7880","author":"Lewis Mike","year":"2020","unstructured":"Mike Lewis , Yinhan Liu , Naman Goyal , Marjan Ghazvininejad , Abdelrahman Mohamed , Omer Levy , Veselin Stoyanov , and Luke Zettlemoyer . 2020 . BART: Denoising Sequence-to-Sequence Pre-training for Natural Language Generation, Translation, and Comprehension . In Proceedings of the 58th Annual Meeting of the Association for Computational Linguistics. 7871--7880 . Mike Lewis, Yinhan Liu, Naman Goyal, Marjan Ghazvininejad, Abdelrahman Mohamed, Omer Levy, Veselin Stoyanov, and Luke Zettlemoyer. 2020. BART: Denoising Sequence-to-Sequence Pre-training for Natural Language Generation, Translation, and Comprehension. In Proceedings of the 58th Annual Meeting of the Association for Computational Linguistics. 7871--7880."},{"key":"e_1_2_1_26_1","doi-asserted-by":"crossref","unstructured":"Fei Li and HV Jagadish. 2014. Constructing an interactive natural language interface for relational databases.  Fei Li and HV Jagadish. 2014. Constructing an interactive natural language interface for relational databases.","DOI":"10.14778\/2735461.2735468"},{"key":"e_1_2_1_27_1","volume-title":"Roberta: A robustly optimized bert pretraining approach. arXiv preprint arXiv:1907.11692","author":"Liu Yinhan","year":"2019","unstructured":"Yinhan Liu , Myle Ott , Naman Goyal , Jingfei Du , Mandar Joshi , Danqi Chen , Omer Levy , Mike Lewis , Luke Zettlemoyer , and Veselin Stoyanov . 2019 . Roberta: A robustly optimized bert pretraining approach. arXiv preprint arXiv:1907.11692 (2019). Yinhan Liu, Myle Ott, Naman Goyal, Jingfei Du, Mandar Joshi, Danqi Chen, Omer Levy, Mike Lewis, Luke Zettlemoyer, and Veselin Stoyanov. 2019. Roberta: A robustly optimized bert pretraining approach. arXiv preprint arXiv:1907.11692 (2019)."},{"key":"e_1_2_1_28_1","first-page":"566","article-title":"Adagrad---an optimizer for stochastic gradient descent","volume":"6","author":"Lydia Agnes","year":"2019","unstructured":"Agnes Lydia and Sagayaraj Francis . 2019 . Adagrad---an optimizer for stochastic gradient descent . Int. J. Inf. Comput. Sci 6 , 5 (2019), 566 -- 568 . Agnes Lydia and Sagayaraj Francis. 2019. Adagrad---an optimizer for stochastic gradient descent. Int. J. Inf. Comput. Sci 6, 5 (2019), 566--568.","journal-title":"Int. J. Inf. Comput. Sci"},{"key":"e_1_2_1_29_1","volume-title":"Hybrid Ranking Network for Text-to-SQL. arXiv preprint arXiv:2008.04759","author":"Lyu Qin","year":"2020","unstructured":"Qin Lyu , Kaushik Chakrabarti , Shobhit Hathi , Souvik Kundu , Jianwen Zhang , and Zheng Chen . 2020. Hybrid Ranking Network for Text-to-SQL. arXiv preprint arXiv:2008.04759 ( 2020 ). Qin Lyu, Kaushik Chakrabarti, Shobhit Hathi, Souvik Kundu, Jianwen Zhang, and Zheng Chen. 2020. Hybrid Ranking Network for Text-to-SQL. arXiv preprint arXiv:2008.04759 (2020)."},{"key":"e_1_2_1_30_1","doi-asserted-by":"crossref","first-page":"569","DOI":"10.14778\/3494124.3494139","article-title":"MT-teql: evaluating and augmenting neural NLIDB on real-world linguistic and schema variations","volume":"15","author":"Ma Pingchuan","year":"2021","unstructured":"Pingchuan Ma and Shuai Wang . 2021 . MT-teql: evaluating and augmenting neural NLIDB on real-world linguistic and schema variations . Proceedings of the VLDB Endowment 15 , 3 (2021), 569 -- 582 . Pingchuan Ma and Shuai Wang. 2021. MT-teql: evaluating and augmenting neural NLIDB on real-world linguistic and schema variations. Proceedings of the VLDB Endowment 15, 3 (2021), 569--582.","journal-title":"Proceedings of the VLDB Endowment"},{"key":"e_1_2_1_31_1","volume-title":"Distributed representations of words and phrases and their compositionality. Advances in neural information processing systems 26","author":"Mikolov Tomas","year":"2013","unstructured":"Tomas Mikolov , Ilya Sutskever , Kai Chen , Greg S Corrado , and Jeff Dean . 2013. Distributed representations of words and phrases and their compositionality. Advances in neural information processing systems 26 ( 2013 ). Tomas Mikolov, Ilya Sutskever, Kai Chen, Greg S Corrado, and Jeff Dean. 2013. Distributed representations of words and phrases and their compositionality. Advances in neural information processing systems 26 (2013)."},{"key":"e_1_2_1_32_1","volume-title":"Proceedings of the 8th international conference on Intelligent user interfaces.","author":"Popescu Ana-Maria","year":"2003","unstructured":"Ana-Maria Popescu , Oren Etzioni , and Henry Kautz . 2003 . Towards a theory of natural language interfaces to databases . In Proceedings of the 8th international conference on Intelligent user interfaces. Ana-Maria Popescu, Oren Etzioni, and Henry Kautz. 2003. Towards a theory of natural language interfaces to databases. In Proceedings of the 8th international conference on Intelligent user interfaces."},{"key":"e_1_2_1_33_1","volume-title":"Exploring the limits of transfer learning with a unified text-to-text transformer. arXiv preprint arXiv:1910.10683","author":"Raffel Colin","year":"2019","unstructured":"Colin Raffel , Noam Shazeer , Adam Roberts , Katherine Lee , Sharan Narang , Michael Matena , Yanqi Zhou , Wei Li , and Peter J Liu . 2019. Exploring the limits of transfer learning with a unified text-to-text transformer. arXiv preprint arXiv:1910.10683 ( 2019 ). Colin Raffel, Noam Shazeer, Adam Roberts, Katherine Lee, Sharan Narang, Michael Matena, Yanqi Zhou, Wei Li, and Peter J Liu. 2019. Exploring the limits of transfer learning with a unified text-to-text transformer. arXiv preprint arXiv:1910.10683 (2019)."},{"key":"e_1_2_1_34_1","volume-title":"URL: http:\/\/redis.io\/topics\/faq Accessed November 17","author":"Redis WG","year":"2016","unstructured":"WG Redis . 2016. Redis. URL: http:\/\/redis.io\/topics\/faq Accessed November 17 ( 2016 ). WG Redis. 2016. Redis. URL: http:\/\/redis.io\/topics\/faq Accessed November 17 (2016)."},{"key":"e_1_2_1_35_1","volume-title":"Proceedings of the 2021 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies. 311--324","author":"Rubin Ohad","year":"2021","unstructured":"Ohad Rubin and Jonathan Berant . 2021 . SmBoP: Semi-autoregressive Bottom-up Semantic Parsing . In Proceedings of the 2021 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies. 311--324 . Ohad Rubin and Jonathan Berant. 2021. SmBoP: Semi-autoregressive Bottom-up Semantic Parsing. In Proceedings of the 2021 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies. 311--324."},{"key":"e_1_2_1_36_1","volume-title":"Ashish R Mittal, and Fatma \u00d6zcan.","author":"Saha Diptikalyan","year":"2016","unstructured":"Diptikalyan Saha , Avrilia Floratou , Karthik Sankaranarayanan , Umar Farooq Minhas , Ashish R Mittal, and Fatma \u00d6zcan. 2016 . ATHENA : an ontology-driven system for natural language querying over relational data stores. Diptikalyan Saha, Avrilia Floratou, Karthik Sankaranarayanan, Umar Farooq Minhas, Ashish R Mittal, and Fatma \u00d6zcan. 2016. ATHENA: an ontology-driven system for natural language querying over relational data stores."},{"key":"e_1_2_1_37_1","volume-title":"Proceedings of the 2021 Conference on Empirical Methods in Natural Language Processing. 9895--9901","author":"Scholak Torsten","year":"2021","unstructured":"Torsten Scholak , Nathan Schucher , and Dzmitry Bahdanau . 2021 . PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Models . In Proceedings of the 2021 Conference on Empirical Methods in Natural Language Processing. 9895--9901 . Torsten Scholak, Nathan Schucher, and Dzmitry Bahdanau. 2021. PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Models. In Proceedings of the 2021 Conference on Empirical Methods in Natural Language Processing. 9895--9901."},{"key":"e_1_2_1_38_1","doi-asserted-by":"crossref","first-page":"2747","DOI":"10.14778\/3407790.3407858","article-title":"ATHENA++ natural language querying for complex nested SQL queries","volume":"13","author":"Sen Jaydeep","year":"2020","unstructured":"Jaydeep Sen , Chuan Lei , Abdul Quamar , Fatma \u00d6zcan , Vasilis Efthymiou , Ayushi Dalmia , Greg Stager , Ashish Mittal , Diptikalyan Saha , and Karthik Sankaranarayanan . 2020 . ATHENA++ natural language querying for complex nested SQL queries . Proceedings of the VLDB Endowment 13 , 12 (2020), 2747 -- 2759 . Jaydeep Sen, Chuan Lei, Abdul Quamar, Fatma \u00d6zcan, Vasilis Efthymiou, Ayushi Dalmia, Greg Stager, Ashish Mittal, Diptikalyan Saha, and Karthik Sankaranarayanan. 2020. ATHENA++ natural language querying for complex nested SQL queries. Proceedings of the VLDB Endowment 13, 12 (2020), 2747--2759.","journal-title":"Proceedings of the VLDB Endowment"},{"key":"e_1_2_1_39_1","volume-title":"Proceedings of the AAAI Conference on Artificial Intelligence","volume":"35","author":"Shi Peng","year":"2021","unstructured":"Peng Shi , Patrick Ng , Zhiguo Wang , Henghui Zhu , Alexander Hanbo Li , Jun Wang , Cicero Nogueira dos Santos , and Bing Xiang . 2021 . Learning Contextual Representations for Semantic Parsing with Generation-Augmented Pre-Training . In Proceedings of the AAAI Conference on Artificial Intelligence , Vol. 35 . 13806--13814. Peng Shi, Patrick Ng, Zhiguo Wang, Henghui Zhu, Alexander Hanbo Li, Jun Wang, Cicero Nogueira dos Santos, and Bing Xiang. 2021. Learning Contextual Representations for Semantic Parsing with Generation-Augmented Pre-Training. In Proceedings of the AAAI Conference on Artificial Intelligence, Vol. 35. 13806--13814."},{"key":"e_1_2_1_40_1","unstructured":"Ilya Sutskever Oriol Vinyals and Quoc V Le. 2014. Sequence to sequence learning with neural networks. In NIPS.  Ilya Sutskever Oriol Vinyals and Quoc V Le. 2014. Sequence to sequence learning with neural networks. In NIPS."},{"key":"e_1_2_1_41_1","unstructured":"Ashish Vaswani Noam Shazeer Niki Parmar Jakob Uszkoreit Llion Jones Aidan N Gomez \u0141ukasz Kaiser and Illia Polosukhin. 2017. Attention is all you need. In NIPS.  Ashish Vaswani Noam Shazeer Niki Parmar Jakob Uszkoreit Llion Jones Aidan N Gomez \u0141ukasz Kaiser and Illia Polosukhin. 2017. Attention is all you need. In NIPS."},{"key":"e_1_2_1_42_1","unstructured":"Oriol Vinyals Meire Fortunato and Navdeep Jaitly. 2015. Pointer networks. In NIPS.  Oriol Vinyals Meire Fortunato and Navdeep Jaitly. 2015. Pointer networks. In NIPS."},{"key":"e_1_2_1_43_1","volume-title":"Proceedings of the 58th Annual Meeting of the Association for Computational Linguistics.","author":"Wang Bailin","year":"2020","unstructured":"Bailin Wang , Richard Shin , Xiaodong Liu , Oleksandr Polozov , and Matthew Richardson . 2020 . RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parsers . In Proceedings of the 58th Annual Meeting of the Association for Computational Linguistics. Bailin Wang, Richard Shin, Xiaodong Liu, Oleksandr Polozov, and Matthew Richardson. 2020. RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parsers. In Proceedings of the 58th Annual Meeting of the Association for Computational Linguistics."},{"key":"e_1_2_1_44_1","volume-title":"Robust text-to-sql generation with execution-guided decoding. arXiv preprint arXiv:1807.03100","author":"Wang Chenglong","year":"2018","unstructured":"Chenglong Wang , Kedar Tatwawadi , Marc Brockschmidt , Po-Sen Huang , Yi Mao , Oleksandr Polozov , and Rishabh Singh . 2018. Robust text-to-sql generation with execution-guided decoding. arXiv preprint arXiv:1807.03100 ( 2018 ). Chenglong Wang, Kedar Tatwawadi, Marc Brockschmidt, Po-Sen Huang, Yi Mao, Oleksandr Polozov, and Rishabh Singh. 2018. Robust text-to-sql generation with execution-guided decoding. arXiv preprint arXiv:1807.03100 (2018)."},{"key":"e_1_2_1_45_1","volume-title":"2020 IEEE 36th International Conference on Data Engineering (ICDE). IEEE, 97--108","author":"Wang Wenlu","year":"2020","unstructured":"Wenlu Wang , Yingtao Tian , Haixun Wang , and Wei-Shinn Ku . 2020 . A Natural Language Interface for Database: Achieving Transfer-learnability Using Adversarial Method for Question Understanding . In 2020 IEEE 36th International Conference on Data Engineering (ICDE). IEEE, 97--108 . Wenlu Wang, Yingtao Tian, Haixun Wang, and Wei-Shinn Ku. 2020. A Natural Language Interface for Database: Achieving Transfer-learnability Using Adversarial Method for Question Understanding. In 2020 IEEE 36th International Conference on Data Engineering (ICDE). IEEE, 97--108."},{"key":"e_1_2_1_46_1","volume-title":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data. 2347--2361","author":"Weir Nathaniel","year":"2020","unstructured":"Nathaniel Weir , Prasetya Utama , Alex Galakatos , Andrew Crotty , Amir Ilkhechi , Shekar Ramaswamy , Rohin Bhushan , Nadja Geisler , Benjamin H\u00e4ttasch , Steffen Eger , 2020 . DBPal: A Fully Pluggable NL2SQL Training Pipeline . In Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data. 2347--2361 . Nathaniel Weir, Prasetya Utama, Alex Galakatos, Andrew Crotty, Amir Ilkhechi, Shekar Ramaswamy, Rohin Bhushan, Nadja Geisler, Benjamin H\u00e4ttasch, Steffen Eger, et al. 2020. DBPal: A Fully Pluggable NL2SQL Training Pipeline. In Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data. 2347--2361."},{"key":"e_1_2_1_47_1","volume-title":"Proceedings of the 2018 Conference on Empirical Methods in Natural Language Processing. 931--936","author":"Xu Kun","year":"2018","unstructured":"Kun Xu , Lingfei Wu , Zhiguo Wang , Yansong Feng , and Vadim Sheinin . 2018 . SQL-to-Text Generation with Graph-to-Sequence Model . In Proceedings of the 2018 Conference on Empirical Methods in Natural Language Processing. 931--936 . Kun Xu, Lingfei Wu, Zhiguo Wang, Yansong Feng, and Vadim Sheinin. 2018. SQL-to-Text Generation with Graph-to-Sequence Model. In Proceedings of the 2018 Conference on Empirical Methods in Natural Language Processing. 931--936."},{"key":"e_1_2_1_48_1","volume-title":"Sqlnet: Generating structured queries from natural language without reinforcement learning. arXiv preprint","author":"Xu Xiaojun","year":"2017","unstructured":"Xiaojun Xu , Chang Liu , and Dawn Song . 2017 . Sqlnet: Generating structured queries from natural language without reinforcement learning. arXiv preprint (2017). Xiaojun Xu, Chang Liu, and Dawn Song. 2017. Sqlnet: Generating structured queries from natural language without reinforcement learning. arXiv preprint (2017)."},{"key":"e_1_2_1_49_1","volume-title":"SeaD: End-to-end Text-to-SQL Generation with Schema-aware Denoising. arXiv preprint arXiv:2105.07911","author":"Xuan Kuan","year":"2021","unstructured":"Kuan Xuan , Yongbo Wang , Yongliang Wang , Zujie Wen , and Yang Dong . 2021. SeaD: End-to-end Text-to-SQL Generation with Schema-aware Denoising. arXiv preprint arXiv:2105.07911 ( 2021 ). Kuan Xuan, Yongbo Wang, Yongliang Wang, Zujie Wen, and Yang Dong. 2021. SeaD: End-to-end Text-to-SQL Generation with Schema-aware Denoising. arXiv preprint arXiv:2105.07911 (2021)."},{"key":"e_1_2_1_50_1","doi-asserted-by":"crossref","unstructured":"Navid Yaghmazadeh Yuepeng Wang Isil Dillig and Thomas Dillig. 2017. SQLizer: query synthesis from natural language. PACMPL.  Navid Yaghmazadeh Yuepeng Wang Isil Dillig and Thomas Dillig. 2017. SQLizer: query synthesis from natural language. PACMPL.","DOI":"10.1145\/3133887"},{"key":"e_1_2_1_51_1","unstructured":"Pengcheng Yin Zhengdong Lu Hang Li and Ben Kao. 2016. Neural enquirer: learning to query tables in natural language. In IJCAI.  Pengcheng Yin Zhengdong Lu Hang Li and Ben Kao. 2016. Neural enquirer: learning to query tables in natural language. In IJCAI."},{"key":"e_1_2_1_52_1","volume-title":"Proceedings of the 55th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers). 440--450","author":"Yin Pengcheng","year":"2017","unstructured":"Pengcheng Yin and Graham Neubig . 2017 . A Syntactic Neural Model for General-Purpose Code Generation . In Proceedings of the 55th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers). 440--450 . Pengcheng Yin and Graham Neubig. 2017. A Syntactic Neural Model for General-Purpose Code Generation. In Proceedings of the 55th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers). 440--450."},{"key":"e_1_2_1_53_1","volume-title":"GraPPa: Grammar-Augmented Pre-Training for Table Semantic Parsing. In International Conference on Learning Representations.","author":"Yu Tao","year":"2021","unstructured":"Tao Yu , Chien-Sheng Wu , Xi Victoria Lin , Yi Chern Tan , Xinyi Yang , Dragomir Radev , Caiming Xiong , 2021 . GraPPa: Grammar-Augmented Pre-Training for Table Semantic Parsing. In International Conference on Learning Representations. Tao Yu, Chien-Sheng Wu, Xi Victoria Lin, Yi Chern Tan, Xinyi Yang, Dragomir Radev, Caiming Xiong, et al. 2021. GraPPa: Grammar-Augmented Pre-Training for Table Semantic Parsing. In International Conference on Learning Representations."},{"key":"e_1_2_1_54_1","volume-title":"Proceedings of the 2018 Conference on Empirical Methods in Natural Language Processing.","author":"Yu Tao","year":"2018","unstructured":"Tao Yu , Michihiro Yasunaga , Kai Yang , Rui Zhang , Dongxu Wang , Zifan Li , and Dragomir Radev . 2018 . SyntaxSQLNet: Syntax Tree Networks for Complex and Cross-Domain Text-to-SQL Task . In Proceedings of the 2018 Conference on Empirical Methods in Natural Language Processing. Tao Yu, Michihiro Yasunaga, Kai Yang, Rui Zhang, Dongxu Wang, Zifan Li, and Dragomir Radev. 2018. SyntaxSQLNet: Syntax Tree Networks for Complex and Cross-Domain Text-to-SQL Task. In Proceedings of the 2018 Conference on Empirical Methods in Natural Language Processing."},{"key":"e_1_2_1_55_1","volume-title":"Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-sql task.","author":"Yu Tao","year":"2018","unstructured":"Tao Yu , Rui Zhang , Kai Yang , Michihiro Yasunaga , Dongxu Wang , Zifan Li , James Ma , Irene Li , Qingning Yao , Shanelle Roman , 2018 . Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-sql task. Tao Yu, Rui Zhang, Kai Yang, Michihiro Yasunaga, Dongxu Wang, Zifan Li, James Ma, Irene Li, Qingning Yao, Shanelle Roman, et al. 2018. Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-sql task."},{"key":"e_1_2_1_56_1","volume-title":"Proceedings of the national conference on artificial intelligence. 1050--1055","author":"Zelle John M","year":"1996","unstructured":"John M Zelle and Raymond J Mooney . 1996 . Learning to parse database queries using inductive logic programming . In Proceedings of the national conference on artificial intelligence. 1050--1055 . John M Zelle and Raymond J Mooney. 1996. Learning to parse database queries using inductive logic programming. In Proceedings of the national conference on artificial intelligence. 1050--1055."},{"key":"e_1_2_1_57_1","volume-title":"Proceedings of the Twenty-First Conference on Uncertainty in Artificial Intelligence.","author":"Zettlemoyer Luke S","year":"2005","unstructured":"Luke S Zettlemoyer and Michael Collins . 2005 . Learning to map sentences to logical form: structured classification with probabilistic categorial grammars . In Proceedings of the Twenty-First Conference on Uncertainty in Artificial Intelligence. Luke S Zettlemoyer and Michael Collins. 2005. Learning to map sentences to logical form: structured classification with probabilistic categorial grammars. In Proceedings of the Twenty-First Conference on Uncertainty in Artificial Intelligence."},{"key":"e_1_2_1_58_1","volume-title":"Seq2sql: Generating structured queries from natural language using reinforcement learning. arXiv preprint","author":"Zhong Victor","year":"2017","unstructured":"Victor Zhong , Caiming, and Richard Socher . 2017. Seq2sql: Generating structured queries from natural language using reinforcement learning. arXiv preprint ( 2017 ). Victor Zhong, Caiming, and Richard Socher. 2017. Seq2sql: Generating structured queries from natural language using reinforcement learning. arXiv preprint (2017)."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3583140.3583165","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,4,20]],"date-time":"2023-04-20T16:56:28Z","timestamp":1682009788000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3583140.3583165"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,2]]},"references-count":58,"journal-issue":{"issue":"6","published-print":{"date-parts":[[2023,2]]}},"alternative-id":["10.14778\/3583140.3583165"],"URL":"https:\/\/doi.org\/10.14778\/3583140.3583165","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2023,2]]},"assertion":[{"value":"2023-04-20","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}