{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,24]],"date-time":"2025-11-24T09:25:26Z","timestamp":1763976326145,"version":"3.37.3"},"reference-count":32,"publisher":"Springer Science and Business Media LLC","issue":"15","license":[{"start":{"date-parts":[[2023,10,21]],"date-time":"2023-10-21T00:00:00Z","timestamp":1697846400000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2023,10,21]],"date-time":"2023-10-21T00:00:00Z","timestamp":1697846400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Multimed Tools Appl"],"DOI":"10.1007\/s11042-023-16987-2","type":"journal-article","created":{"date-parts":[[2023,10,21]],"date-time":"2023-10-21T06:01:33Z","timestamp":1697868093000},"page":"45391-45405","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":3,"title":["Translating natural language questions to SQL queries (nested queries)"],"prefix":"10.1007","volume":"83","author":[{"given":"Sindhuja","family":"Swamidorai","sequence":"first","affiliation":[]},{"given":"T Satyanarayana","family":"Murthy","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0002-0453-0645","authenticated-orcid":false,"given":"K V","family":"Sriharsha","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2023,10,21]]},"reference":[{"key":"16987_CR1","volume-title":"Auto-Query-A simple natural language to SQL query generator for an e-learning platform","author":"P Parikh","year":"1999","unstructured":"Parikh P, Chatterjee O, Jain M, Harsh A, Shahani G, Biswas R, Arya K (1999) Auto-Query-A simple natural language to SQL query generator for an e-learning platform. Academie Press, New York"},{"key":"16987_CR2","first-page":"1","volume":"2021","author":"A Wong","year":"2021","unstructured":"Wong A, Joiner D, Chiu C, Elsayed M, Pereira K, Khmelevsky Y, Mahony J (2021) A Survey of Natural Language Processing Implementation for Data Query Systems. IEEE International Conference on Recent Advances in Systems Science and Engineering (RASSE) 2021:1\u20138","journal-title":"IEEE International Conference on Recent Advances in Systems Science and Engineering (RASSE)"},{"issue":"1","key":"16987_CR3","first-page":"147","volume":"4","author":"MS Baig","year":"2022","unstructured":"Baig MS, Imran A, Yasin AU, Butt AH, Khan MI (2022) Natural Language to SQL Queries: A Review. Technol 4(1):147\u2013162","journal-title":"Technol"},{"unstructured":"Sutskever I, Vinyals O, Le QV (2014) Sequence to sequence learning with neural networks. Adv Neural Inf Process Syst 27","key":"16987_CR4"},{"doi-asserted-by":"crossref","unstructured":"Yu T, Zhang R, Yang K, Yasunaga M, Wang D, Li Z, Ma J, Li I, Yao Q, Roman S et al. (2018) Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-sql task. arXiv:1809.08887","key":"16987_CR5","DOI":"10.18653\/v1\/D18-1425"},{"doi-asserted-by":"crossref","unstructured":"Wang B, Shin R, Liu X, Polozov O, Richardson M (2019) Rat-sql: Relation-aware schema encoding and linking for text-to-sql parser. arXiv:1911.04942","key":"16987_CR6","DOI":"10.18653\/v1\/2020.acl-main.677"},{"unstructured":"Zhong V, Xiong C, Socher R (2017) Seq2sql: Generating structured queries from natural language using reinforcement learning. arXiv:1709.0010","key":"16987_CR7"},{"doi-asserted-by":"crossref","unstructured":"Yu T, Yasunaga M, Yang K, Zhang R, Wang D, Li Z, Radev D (2018) Syntaxsqlnet: Syntax tree networks for complex and cross-domaintext-to-sql task. arXiv:1810.05237","key":"16987_CR8","DOI":"10.18653\/v1\/D18-1193"},{"unstructured":"Lin K, Bogin B, Neumann M, Berant J, Gardner M (2019) Grammar-based neural text-to-sql generation. arXiv:1905.13326","key":"16987_CR9"},{"doi-asserted-by":"crossref","unstructured":"Yu T, Li Z, Zhang Z, Zhang R, Radev D (2018) Typesql: Knowledge-based type-aware neural text-to-sql generation. arXiv:1804.09769","key":"16987_CR10","DOI":"10.18653\/v1\/N18-2093"},{"doi-asserted-by":"crossref","unstructured":"Guo J, Zhan Z, Gao Y, Xiao Y, Lou J-G, Liu T, Zhang D (2019) Towards complex text-to-sql in cross-domain database with intermediate representation. arXiv:1905.08205","key":"16987_CR11","DOI":"10.18653\/v1\/P19-1444"},{"doi-asserted-by":"crossref","unstructured":"Gan Y, Chen X, Xie J, Purver M, Woodward JR, Drake J, Zhang Q (2021) Natural SQL: making SQL easier to infer from natural language specifications. arXiv:2109.05153","key":"16987_CR12","DOI":"10.18653\/v1\/2021.findings-emnlp.174"},{"issue":"4","key":"16987_CR13","doi-asserted-by":"publisher","first-page":"2542","DOI":"10.1109\/TII.2019.2952929","volume":"16","author":"Q Li","year":"2019","unstructured":"Li Q, Li L, Li Q, Zhong J (2019) A comprehensive exploration on spider with fuzzy decision text-to-SQL model. IEEE Trans Ind Inf 16(4):2542\u20132550 (IEEE)","journal-title":"IEEE Trans Ind Inf"},{"unstructured":"Devlin J, Chang M-W, Lee K, Toutanova K (2018) Bert: Pre-training of deep bidirectional transformers for language understanding. arXiv:1810.04805","key":"16987_CR14"},{"doi-asserted-by":"crossref","unstructured":"Scholak T, Schucher N, Bahdanau D (2021) PICARD: Parsing incrementally for constrained auto-regressive decoding from language models. arXiv:2109.05093","key":"16987_CR15","DOI":"10.18653\/v1\/2021.emnlp-main.779"},{"doi-asserted-by":"crossref","unstructured":"Ning Z, Zhang D, Zhang L, Yu H, Wan F (2021) Review of question answering technology based on Text to SQL. 2021 IEEE International Conference on Power Electronics, Computer Applications (ICPECA) 143\u2013146. IEEE","key":"16987_CR16","DOI":"10.1109\/ICPECA51329.2021.9362554"},{"key":"16987_CR17","volume-title":"A Review of NLIDB with Deep Learning: Findings","author":"S Abbas","year":"2022","unstructured":"Abbas S, Khan MU, Lee SU-J, Abbas A, Bashir AK (2022) A Review of NLIDB with Deep Learning: Findings. Challenges and Open Issues. IEEE Access, IEEE"},{"doi-asserted-by":"crossref","unstructured":"Brunner U, Stockinger K (2021) Valuenet: A natural language-to-sql system that learns from database information. 2021 IEEE 37th International Conference on Data Engineering (ICDE) 2177\u20132182. IEEE","key":"16987_CR18","DOI":"10.1109\/ICDE51399.2021.00220"},{"key":"16987_CR19","doi-asserted-by":"publisher","first-page":"359","DOI":"10.1016\/j.neucom.2021.08.134","volume":"465","author":"A Guo","year":"2021","unstructured":"Guo A, Zhao X, Ma W (2021) ER-SQL: Learning enhanced representation for Text-to-SQL using table contents. Neurocomput 465:359\u2013370 (Elseiver)","journal-title":"Neurocomput"},{"doi-asserted-by":"crossref","unstructured":"Rubin O, Berant J (2020) SmBoP: Semi-autoregressive bottom-up semantic parsing. arXiv:2010.12412","key":"16987_CR20","DOI":"10.18653\/v1\/2021.naacl-main.29"},{"doi-asserted-by":"crossref","unstructured":"Bogin B, Gardner M, Berant J (2019) Representing schema structure with graph neural networks for text-to-SQL parsing. arXiv:1905.06241","key":"16987_CR21","DOI":"10.18653\/v1\/P19-1448"},{"doi-asserted-by":"crossref","unstructured":"Hui B, Geng R, Wang L, Qin B, Li B, Sun J, Li Y (2022) S$$^{2}$$ SQL: Injecting Syntax to Question-Schema Interaction Graph Encoder for Text-to-SQL Parsers. arXiv:2203.06958","key":"16987_CR22","DOI":"10.18653\/v1\/2022.findings-acl.99"},{"key":"16987_CR23","doi-asserted-by":"publisher","first-page":"4233","DOI":"10.1109\/ACCESS.2020.3048164","volume":"9","author":"T Bai","year":"2020","unstructured":"Bai T, Ge Y, Guo S, Zhang Z, Gong L (2020) Enhanced natural language interface for web-based information retrieval. IEEE Access 9:4233\u20134241 (IEEE)","journal-title":"IEEE Access"},{"unstructured":"Clark K, Luong M-T, Le QV, Manning CD (2020) Electra: Pre-training text encoders as discriminators rather than generators. arXiv:2003.10555","key":"16987_CR24"},{"doi-asserted-by":"crossref","unstructured":"Chen Z, Chen L, Zhao Y, Cao R, Xu Z, Zhu S, Yu K (2021) ShadowGNN: Graph projection neural network for text-to-SQL parser. arXiv:2104.04689","key":"16987_CR25","DOI":"10.18653\/v1\/2021.naacl-main.441"},{"doi-asserted-by":"crossref","unstructured":"Cao R, Chen L, Chen Z, Zhao Y, Zhu S, Yu K (2021) LGESQL: line graph enhanced text-to-SQL model with mixed local and non-local relations. arXiv:2106.01093","key":"16987_CR26","DOI":"10.18653\/v1\/2021.acl-long.198"},{"doi-asserted-by":"crossref","unstructured":"Xie T, Wu CH, Shi P, Zhong R, Scholak T, Yasunaga M, Wu C-S, Zhong MY (2022) Pengcheng and Wang, Sida I and others,Unifiedskg: Unifying and multi-tasking structured knowledge grounding with text-to-text language models. arXiv:2201.05966","key":"16987_CR27","DOI":"10.18653\/v1\/2022.emnlp-main.39"},{"issue":"2","key":"16987_CR28","doi-asserted-by":"publisher","first-page":"1937","DOI":"10.1007\/s11063-018-09977-1","volume":"50","author":"YS Aurelio","year":"2019","unstructured":"Aurelio YS, de Almeida GM, de Castro CL, Braga AP (2019) Learning from imbalanced data sets w, ith weighted cross-entropy function. Neural Process Lett 50(2):1937\u20131949 (Springer)","journal-title":"Neural Process Lett"},{"issue":"1","key":"16987_CR29","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1186\/s40537-021-00492-0","volume":"8","author":"C Shorten","year":"2021","unstructured":"Shorten C, Khoshgoftaar TM, Furht B (2021) Text data augmentation for deep learning. J Big Data 8(1):1\u201334 (Springer)","journal-title":"J Big Data"},{"unstructured":"Choi DH, Shin MC, Kim EG, Shin DR (2021) Ryansql: Recursively applyin,g sketch-based slot fillings for complex text-to-sql in cross-domain databases. Comput Linguist 47(2):309\u2013332. MIT Press One Rogers Street, Cambridge, MA 02142-1209, USA journals-info","key":"16987_CR30"},{"key":"16987_CR31","first-page":"7664","volume":"34","author":"R Cai","year":"2021","unstructured":"Cai R, Yuan J, Xu B, Hao Z (2021) SADGA: Structure-Aware Dual Graph Aggregation Network for Text-to-SQL. Adv Neural Inf Process Syst 34:7664\u20137676","journal-title":"Adv Neural Inf Process Syst"},{"issue":"1","key":"16987_CR32","doi-asserted-by":"publisher","first-page":"80","DOI":"10.1017\/S1471068419000449","volume":"21","author":"F Calimeri","year":"2021","unstructured":"Calimeri F, Cauteruccio F, Cinelli L, Marzullo A, Stamile C, Terracina G, Durand-Dubief F, Sappey-Marinier D (2021) A logic-based framework leveraging neural networks for studying the evolution of neurological disorders. Theory Pract Log Program 21(1):80\u2013124","journal-title":"Theory Pract Log Program"}],"container-title":["Multimedia Tools and Applications"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s11042-023-16987-2.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s11042-023-16987-2\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s11042-023-16987-2.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,4,29]],"date-time":"2024-04-29T11:41:47Z","timestamp":1714390907000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s11042-023-16987-2"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,10,21]]},"references-count":32,"journal-issue":{"issue":"15","published-online":{"date-parts":[[2024,5]]}},"alternative-id":["16987"],"URL":"https:\/\/doi.org\/10.1007\/s11042-023-16987-2","relation":{},"ISSN":["1573-7721"],"issn-type":[{"type":"electronic","value":"1573-7721"}],"subject":[],"published":{"date-parts":[[2023,10,21]]},"assertion":[{"value":"23 January 2023","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"24 August 2023","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"4 September 2023","order":3,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"21 October 2023","order":4,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}},{"order":1,"name":"Ethics","group":{"name":"EthicsHeading","label":"Declarations"}},{"value":"On behalf of all authors, the corresponding author states that there is no confict of interest.","order":2,"name":"Ethics","group":{"name":"EthicsHeading","label":"Competing Interest"}}]}}