{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,24]],"date-time":"2026-07-24T18:35:47Z","timestamp":1784918147921,"version":"3.55.0"},"publisher-location":"Singapore","reference-count":42,"publisher":"Springer Nature Singapore","isbn-type":[{"value":"9789819970216","type":"print"},{"value":"9789819970223","type":"electronic"}],"license":[{"start":{"date-parts":[[2023,11,10]],"date-time":"2023-11-10T00:00:00Z","timestamp":1699574400000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2023,11,10]],"date-time":"2023-11-10T00:00:00Z","timestamp":1699574400000},"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":[],"published-print":{"date-parts":[[2024]]},"DOI":"10.1007\/978-981-99-7022-3_23","type":"book-chapter","created":{"date-parts":[[2023,11,10]],"date-time":"2023-11-10T00:02:57Z","timestamp":1699574577000},"page":"262-274","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":14,"title":["Prompting GPT-3.5 for\u00a0Text-to-SQL with\u00a0De-semanticization and\u00a0Skeleton Retrieval"],"prefix":"10.1007","author":[{"given":"Chunxi","family":"Guo","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Zhiliang","family":"Tian","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Jintao","family":"Tang","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Pancheng","family":"Wang","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Zhihua","family":"Wen","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Kang","family":"Yang","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ting","family":"Wang","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"297","published-online":{"date-parts":[[2023,11,10]]},"reference":[{"key":"23_CR1","doi-asserted-by":"crossref","unstructured":"Wang, B., Shin, R., Liu, X., Polozov, O., Richardson, M.: RAT-SQL: relation-aware schema encoding and linking for text-to-SQL parsers. ACL (2020)","DOI":"10.18653\/v1\/2020.acl-main.677"},{"key":"23_CR2","doi-asserted-by":"crossref","unstructured":"Cai, R., Xu, B., Zhang, Z., Yang, X., Li, Z., Liang, Z.: An encoder-decoder framework translating natural language to database queries. In: IJCAI (2018)","DOI":"10.24963\/ijcai.2018\/553"},{"key":"23_CR3","unstructured":"Li, H., Zhang, J., Li, C., Chen, H.: Decoupling the skeleton parsing and schema linking for text-to-SQL. arXiv:2302.05965 (2023)"},{"key":"23_CR4","doi-asserted-by":"crossref","unstructured":"Li, J., Hui, B., et al.: Graphix-T5: mixing pre-trained transformers with graph-aware layers for text-to-SQL parsing. arXiv:2301.07507 (2023)","DOI":"10.1609\/aaai.v37i11.26536"},{"key":"23_CR5","unstructured":"Zhao, W.X., Zhou, K., Li, J., et al.: A survey of large language models. arXiv preprint arXiv:2303.18223 (2023)"},{"key":"23_CR6","unstructured":"Brown, T., Mann, B., Ryder, N., et al.: Language models are few-shot learners. In: NIPS, vol. 33, pp. 1877\u20131901 (2020)"},{"key":"23_CR7","unstructured":"Chen, M., Tworek, J., Jun, H., Yuan, Q., Pinto, H.P.D.O., et al.: Evaluating large language models trained on code. arXiv:2107.03374 (2021)"},{"key":"23_CR8","unstructured":"Devlin, J., Chang, M.W., Lee, K., Toutanova, K.: Bert: Pre-training of deep bidirectional transformers for language understanding. In: NAACL (2018)"},{"key":"23_CR9","unstructured":"Zhuang, L., Wayne, L., Ya, S., Jun, Z.: A robustly optimized bert pre-training approach with post-training. In: CCL, pp. 1218\u20131227 (2021)"},{"key":"23_CR10","doi-asserted-by":"crossref","unstructured":"Lewis, M., Liu, Y., et al.: Bart: denoising sequence-to-sequence pre-training for natural language generation, translation, and comprehension. In: ACL (2020)","DOI":"10.18653\/v1\/2020.acl-main.703"},{"key":"23_CR11","first-page":"5485","volume":"21","author":"C Raffel","year":"2020","unstructured":"Raffel, C., Shazeer, N., et al.: Exploring the limits of transfer learning with a unified text-to-text transformer. JMLR 21, 5485\u20135551 (2020)","journal-title":"JMLR"},{"key":"23_CR12","unstructured":"Rajkumar, N., Li, R., Bahdanau, D.: Evaluating the text-to-SQL capabilities of large language models. arXiv:2204.00498 (2022)"},{"key":"23_CR13","unstructured":"Liu, A., Hu, X., Wen, L., Yu, P.S.: A comprehensive evaluation of ChatGPT\u2019s zero-shot text-to-SQL capability. arXiv:2303.13547 (2023)"},{"key":"23_CR14","unstructured":"Cheng, Z., Xie, T., Shi, P., et al.: Binding language models in symbolic languages. In: ICLR (2023)"},{"key":"23_CR15","doi-asserted-by":"crossref","unstructured":"Scholak, T., Schucher, N., Bahdanau, D.: Picard: parsing incrementally for constrained auto-regressive decoding from language models. In: EMNLP (2021)","DOI":"10.18653\/v1\/2021.emnlp-main.779"},{"key":"23_CR16","doi-asserted-by":"crossref","unstructured":"Qi, J., Tang, J., He, Z., et al.: RASAT: integrating relational structures into pretrained Seq2Seq model for text-to-SQL. In: EMNLP, pp. 3215\u20133229 (2022)","DOI":"10.18653\/v1\/2022.emnlp-main.211"},{"key":"23_CR17","unstructured":"Lee, Y.J., Lim, C.G., Choi, H.J.: Does GPT-3 generate empathetic dialogues? A novel in-context example selection method and automatic evaluation metric for empathetic dialogue generation. In: COLING, pp. 669\u2013683 (2022)"},{"key":"23_CR18","unstructured":"Su, H., Kasai, J., et al.: Selective annotation makes language models better few-shot learners. arXiv:2209.01975 (2022)"},{"key":"23_CR19","doi-asserted-by":"crossref","unstructured":"Rubin, O., Herzig, J., Berant, J.: Learning to retrieve prompts for in-context learning. In: NAACL, pp. 2655\u20132671 (2022)","DOI":"10.18653\/v1\/2022.naacl-main.191"},{"key":"23_CR20","doi-asserted-by":"crossref","unstructured":"Guo, J., et al.: Towards complex text-to-SQL in cross-domain database with intermediate representation. In: ACL, pp. 4524\u20134535 (2019)","DOI":"10.18653\/v1\/P19-1444"},{"key":"23_CR21","doi-asserted-by":"crossref","unstructured":"Bogin, B., Berant, J., Gardner, M.: Representing schema structure with graph neural networks for text-to-SQL parsing. In: ACL (2019)","DOI":"10.18653\/v1\/P19-1448"},{"key":"23_CR22","doi-asserted-by":"crossref","unstructured":"Chen, Z., et al.: ShadowGNN: graph projection neural network for text-to-SQL parser. In: NAACL (2021)","DOI":"10.18653\/v1\/2021.naacl-main.441"},{"key":"23_CR23","doi-asserted-by":"crossref","unstructured":"Cao, R., Chen, L., et al.: LGESQL: line graph enhanced text-to-SQL model with mixed local and non-local relations. In: ACL (2021)","DOI":"10.18653\/v1\/2021.acl-long.198"},{"key":"23_CR24","doi-asserted-by":"crossref","unstructured":"Hui, B., Geng, R., Ren, Q., et al.: Dynamic hybrid relation exploration network for cross-domain context-dependent semantic parsing. In: AAAI (2021)","DOI":"10.1609\/aaai.v35i14.17550"},{"key":"23_CR25","doi-asserted-by":"crossref","unstructured":"Hui, B., Geng, R., Wang, L., et al.: S2SQL: injecting syntax to question-schema interaction graph encoder for text-to-SQL parsers. In: ACL, pp. 1254\u20131262 (2022)","DOI":"10.18653\/v1\/2022.findings-acl.99"},{"key":"23_CR26","doi-asserted-by":"crossref","unstructured":"Cai, Z., Li, X., Hui, B., Yang, M., Li, B., et al.: Star: SQL guided pre-training for context-dependent text-to-SQL parsing. In: EMNLP (2022)","DOI":"10.18653\/v1\/2022.findings-emnlp.89"},{"key":"23_CR27","doi-asserted-by":"crossref","unstructured":"Lin, X.V., Socher, R., Xiong, C.: Bridging textual and tabular data for cross-domain text-to-SQL semantic parsing. In: EMNLP, pp. 4870\u20134888 (2020)","DOI":"10.18653\/v1\/2020.findings-emnlp.438"},{"key":"23_CR28","unstructured":"He, P., Mao, Y., Chakrabarti, K., Chen, W.: X-SQL: reinforce schema representation with context. arXiv:1908.08113 (2019)"},{"key":"23_CR29","unstructured":"Lyu, Q., Chakrabarti, K., Hathi, S., Kundu, S., Zhang, J., Chen, Z.: Hybrid ranking network for text-to-SQL. arXiv preprint arXiv:2008.04759 (2020)"},{"key":"23_CR30","doi-asserted-by":"crossref","unstructured":"Zhong, V., Lewis, M., Wang, S.I., Zettlemoyer, L.: Grounded adaptation for zero-shot executable semantic parsing. In: EMNLP, pp. 6869\u20136882 (2020)","DOI":"10.18653\/v1\/2020.emnlp-main.558"},{"key":"23_CR31","doi-asserted-by":"crossref","unstructured":"Choi, D., Shin, M.C., Kim, E., Shin, D.R.: Ryansql: recursively applying sketch-based slot fillings for complex text-to-SQL in cross-domain databases. CL 47(2), 309\u2013332 (2021)","DOI":"10.1162\/coli_a_00403"},{"key":"23_CR32","series-title":"Lecture Notes in Computer Science (Lecture Notes in Artificial Intelligence)","doi-asserted-by":"publisher","first-page":"294","DOI":"10.1007\/978-3-030-86957-1_20","volume-title":"Case-Based Reasoning Research and Development","author":"W Yu","year":"2021","unstructured":"Yu, W., Guo, X., Chen, F., Chang, T., Wang, M., Wang, X.: Similar questions correspond to similar SQL queries: a case-based reasoning approach for text-to-SQL translation. In: S\u00e1nchez-Ruiz, A.A., Floyd, M.W. (eds.) ICCBR 2021. LNCS (LNAI), vol. 12877, pp. 294\u2013308. Springer, Cham (2021). https:\/\/doi.org\/10.1007\/978-3-030-86957-1_20"},{"key":"23_CR33","doi-asserted-by":"crossref","unstructured":"Tian, Z., Bi, W., Li, X., Zhang, N.L.: Learning to abstract for memory-augmented conversational response generation. In: ACL, pp. 3816\u20133825 (2019)","DOI":"10.18653\/v1\/P19-1371"},{"key":"23_CR34","doi-asserted-by":"crossref","unstructured":"Song, Y., et al.: Retrieval bias aware ensemble model for conditional sentence generation. In: ICASSP, pp. 6602\u20136606. IEEE (2022)","DOI":"10.1109\/ICASSP43922.2022.9747307"},{"key":"23_CR35","doi-asserted-by":"crossref","unstructured":"Wen, Z., et al.: Grace: gradient-guided controllable retrieval for augmenting attribute-based text generation. In: Findings of ACL 2023, pp. 8377\u20138398 (2023)","DOI":"10.18653\/v1\/2023.findings-acl.530"},{"key":"23_CR36","unstructured":"Ganea, O., B\u00e9cigneul, G., Hofmann, T.: Hyperbolic neural networks. In: NIPS (2018)"},{"key":"23_CR37","unstructured":"Chen, B., et al.: Probing bert in hyperbolic spaces. arXiv:2104.03869 (2021)"},{"key":"23_CR38","doi-asserted-by":"crossref","unstructured":"Yu, T., Zhang, R., et al.: Spider: a large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-SQL task. In: EMNLP (2019)","DOI":"10.18653\/v1\/D18-1425"},{"key":"23_CR39","doi-asserted-by":"crossref","unstructured":"Gan, Y., Chen, X., Huang, Q., Purver, M., et al.: Towards robustness of text-to-SQL models against synonym substitution. In: ACL (2021)","DOI":"10.18653\/v1\/2021.acl-long.195"},{"key":"23_CR40","doi-asserted-by":"crossref","unstructured":"Gan, Y., Chen, X., Purver, M.: Exploring underexplored limitations of cross-domain text-to-SQL generalization. In: EMNLP (2021)","DOI":"10.18653\/v1\/2021.emnlp-main.702"},{"key":"23_CR41","doi-asserted-by":"crossref","unstructured":"Zhong, R., Yu, T., Klein, D.: Semantic evaluation for text-to-SQL with distilled test suites. In: EMNLP, pp. 396\u2013411 (2020)","DOI":"10.18653\/v1\/2020.emnlp-main.29"},{"key":"23_CR42","doi-asserted-by":"publisher","first-page":"535","DOI":"10.1109\/TBDATA.2019.2921572","volume":"7","author":"J Johnson","year":"2019","unstructured":"Johnson, J., Douze, M., Jegou, H.: Billion-scale similarity search with GPUs. IEEE Trans. Big Data 7, 535\u2013547 (2019)","journal-title":"IEEE Trans. Big Data"}],"container-title":["Lecture Notes in Computer Science","PRICAI 2023: Trends in Artificial Intelligence"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-981-99-7022-3_23","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,11,10]],"date-time":"2023-11-10T00:11:26Z","timestamp":1699575086000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-981-99-7022-3_23"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,11,10]]},"ISBN":["9789819970216","9789819970223"],"references-count":42,"URL":"https:\/\/doi.org\/10.1007\/978-981-99-7022-3_23","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"value":"0302-9743","type":"print"},{"value":"1611-3349","type":"electronic"}],"subject":[],"published":{"date-parts":[[2023,11,10]]},"assertion":[{"value":"10 November 2023","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"PRICAI","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Pacific Rim International Conference on Artificial Intelligence","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Jakarta","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Indonesia","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2023","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"15 November 2023","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"19 November 2023","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"20","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"pricai2023","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/www.pricai.org\/2023\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Double-blind","order":1,"name":"type","label":"Type","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"EasyChair","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"422","order":3,"name":"number_of_submissions_sent_for_review","label":"Number of Submissions Sent for Review","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"95","order":4,"name":"number_of_full_papers_accepted","label":"Number of Full Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"36","order":5,"name":"number_of_short_papers_accepted","label":"Number of Short Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"23% - The value is computed by the equation \"Number of Full Papers Accepted \/ Number of Submissions Sent for Review * 100\" and then rounded to a whole number.","order":6,"name":"acceptance_rate_of_full_papers","label":"Acceptance Rate of Full Papers","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"3.4","order":7,"name":"average_number_of_reviews_per_paper","label":"Average Number of Reviews per Paper","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"3.1","order":8,"name":"average_number_of_papers_per_reviewer","label":"Average Number of Papers per Reviewer","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"Yes","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}