{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,1,23]],"date-time":"2026-01-23T03:46:42Z","timestamp":1769140002615,"version":"3.49.0"},"publisher-location":"Singapore","reference-count":45,"publisher":"Springer Nature Singapore","isbn-type":[{"value":"9789819557158","type":"print"},{"value":"9789819557165","type":"electronic"}],"license":[{"start":{"date-parts":[[2026,1,1]],"date-time":"2026-01-01T00:00:00Z","timestamp":1767225600000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2026,1,1]],"date-time":"2026-01-01T00:00:00Z","timestamp":1767225600000},"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":[[2026]]},"DOI":"10.1007\/978-981-95-5716-5_5","type":"book-chapter","created":{"date-parts":[[2026,1,22]],"date-time":"2026-01-22T13:06:55Z","timestamp":1769087215000},"page":"64-79","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["GRAY: Enhancing Few-Shot NL2SQL Translation Through Incremental SQL Log-Based Demonstration Expansion"],"prefix":"10.1007","author":[{"given":"Zhuo","family":"Chen","sequence":"first","affiliation":[]},{"given":"Kun","family":"Wu","sequence":"additional","affiliation":[]},{"given":"Zhen","family":"Li","sequence":"additional","affiliation":[]},{"given":"Yaxi","family":"Hou","sequence":"additional","affiliation":[]},{"given":"Wenhu","family":"Yu","sequence":"additional","affiliation":[]},{"given":"Zhongju","family":"Liu","sequence":"additional","affiliation":[]},{"given":"Hangxuan","family":"Li","sequence":"additional","affiliation":[]},{"given":"Zihang","family":"Liang","sequence":"additional","affiliation":[]},{"given":"Haoyu","family":"Qin","sequence":"additional","affiliation":[]},{"given":"Tonghui","family":"Ren","sequence":"additional","affiliation":[]},{"given":"Zhenying","family":"He","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2026,1,23]]},"reference":[{"key":"5_CR1","doi-asserted-by":"crossref","unstructured":"Androutsopoulos, I., Ritchie, G.D., Thanisch, P.: Natural language interfaces to databases\u2013an introduction. In: Natural Language Engineering, pp. 29\u201381 (1995)","DOI":"10.1017\/S135132490000005X"},{"key":"5_CR2","unstructured":"Arora, A., et\u00a0al.: A generic prompt for an llm that enables nl-to-sql across domains and compositions. In: ICLR, pp.\u00a01\u20135 (2023)"},{"key":"5_CR3","doi-asserted-by":"crossref","unstructured":"Bogin, B., Gardner, M., Berant, J.: Representing schema structure with graph neural networks for text-to-sql parsing. In: ACL (2019)","DOI":"10.18653\/v1\/P19-1448"},{"key":"5_CR4","unstructured":"Bogin, B., et\u00a0al.: Global reasoning over database structures for text-to-SQL parsing. In: EMNLP, pp. 3659\u20133664 (2019)"},{"key":"5_CR5","unstructured":"Cafero\u011flu, H.A., Ulusoy, \u00d6.: E-sql: Direct schema linking via question enrichment in text-to-sql. arXiv preprint arXiv:2409.16751 (2024)"},{"key":"5_CR6","unstructured":"Cao, Z., Zheng, Y., Fan, Z., Zhang, X., Chen, W., Bai, X.: Rsl-sql: Robust schema linking in text-to-sql generation. arXiv preprint arXiv:2411.00073 (2024)"},{"key":"5_CR7","unstructured":"Chen, X., et\u00a0al.: Open-sql framework: Enhancing text-to-sql on open-source large language models. arXiv preprint arXiv:2405.06674 (2024)"},{"key":"5_CR8","unstructured":"Dong, X., et\u00a0al.: C3: Zero-shot text-to-sql with chatgpt. In: CoRR (2023)"},{"key":"5_CR9","doi-asserted-by":"crossref","unstructured":"Elgohary, A., et\u00a0al.: Nl-edit: Correcting semantic parse errors through natural language interaction. In: NAACL (2021)","DOI":"10.18653\/v1\/2021.naacl-main.444"},{"key":"5_CR10","doi-asserted-by":"crossref","unstructured":"Fan, J., et\u00a0al.: Combining small language models and large language models for zero-shot nl2sql. In: VLDB Endowment, pp. 2750\u20132763 (2024)","DOI":"10.14778\/3681954.3681960"},{"key":"5_CR11","doi-asserted-by":"crossref","unstructured":"Fan, Y., et\u00a0al.: Gar: a generate-and-rank approach for natural language to sql translation. In: ICDE, pp. 110\u2013122. IEEE (2023)","DOI":"10.1109\/ICDE55515.2023.00016"},{"key":"5_CR12","doi-asserted-by":"crossref","unstructured":"Fan, Y., et\u00a0al.: Metasql: a generate-then-rank framework for natural language to sql translation. In: ICDE (2024)","DOI":"10.1109\/ICDE60146.2024.00143"},{"key":"5_CR13","doi-asserted-by":"crossref","unstructured":"Fan, Y., Ren, T., He, Z., Wang, X.S., Zhang, Y., Li, X.: Gensql: A generative natural language interface to database systems. In: ICDE, pp. 3603\u20133606. IEEE (2023)","DOI":"10.1109\/ICDE55515.2023.00278"},{"key":"5_CR14","doi-asserted-by":"crossref","unstructured":"Gao, D., et\u00a0al.: Text-to-sql empowered by large language models: A benchmark evaluation. In: VLDB Endowment (2023)","DOI":"10.14778\/3641204.3641221"},{"key":"5_CR15","unstructured":"Gao, Y., et\u00a0al.: Xiyan-sql: A multi-generator ensemble framework for text-to-sql. arXiv preprint arXiv:2411.08599 (2024)"},{"key":"5_CR16","unstructured":"Gu, Z., et\u00a0al.: Interleaving pre-trained language models and large language models for zero-shot nl2sql generation. In: CoRR (2023)"},{"key":"5_CR17","doi-asserted-by":"crossref","unstructured":"Guo, C., Tian, Z., Tang, J., Wang, P., Wen, Z., Yang, K., Wang, T.: Prompting gpt-3.5 for text-to-sql with de-semanticization and skeleton retrieval. In: PRICAI, pp. 262\u2013274. Springer (2023)","DOI":"10.1007\/978-981-99-7022-3_23"},{"key":"5_CR18","doi-asserted-by":"crossref","unstructured":"Guo, J., et\u00a0al.: Towards complex text-to-sql in cross-domain database with intermediate representation. In: ACL (2019)","DOI":"10.18653\/v1\/P19-1444"},{"key":"5_CR19","doi-asserted-by":"crossref","unstructured":"Hong, Z., et\u00a0al.: Knowledge-to-sql: Enhancing sql generation with data expert llm. In: ACL (2024)","DOI":"10.18653\/v1\/2024.findings-acl.653"},{"key":"5_CR20","doi-asserted-by":"crossref","unstructured":"Katsogiannis-Meimarakis, G., Koutrika, G.: A deep dive into deep learning approaches for text-to-sql systems. In: SIGMOD, pp. 2846\u20132851 (2021)","DOI":"10.1145\/3448016.3457543"},{"key":"5_CR21","doi-asserted-by":"crossref","unstructured":"Kim, H., So, B.H., Han, W.S., Lee, H.: Natural language to sql: Where are we today? In: VLDB Endowment, pp. 1737\u20131750 (2020)","DOI":"10.14778\/3401960.3401970"},{"key":"5_CR22","doi-asserted-by":"crossref","unstructured":"Kokkalis, A., et\u00a0al.: Logos: a system for translating queries into narratives. In: SIGMOD, pp. 673\u2013676 (2012)","DOI":"10.1145\/2213836.2213929"},{"key":"5_CR23","doi-asserted-by":"crossref","unstructured":"Koutrika, G., Simitsis, A., Ioannidis, Y.E.: Explaining structured queries in natural language. In: ICDE, pp. 333\u2013344. IEEE (2010)","DOI":"10.1109\/ICDE.2010.5447824"},{"key":"5_CR24","unstructured":"Lee, D., et\u00a0al.: Mcs-sql: leveraging multiple prompts and multiple-choice selection for text-to-sql generation. In: COLING (2025)"},{"key":"5_CR25","doi-asserted-by":"crossref","unstructured":"Li, H., et\u00a0al.: Codes: Towards building open-source language models for text-to-sql. In: PACMMOD, pp. 1\u201328 (2024)","DOI":"10.1145\/3654930"},{"key":"5_CR26","doi-asserted-by":"crossref","unstructured":"Li, H., Zhang, J., Li, C., Chen, H.: Resdsql: decoupling schema linking and skeleton parsing for text-to-sql. In: AAAI, pp. 13067\u201313075 (2023)","DOI":"10.1609\/aaai.v37i11.26535"},{"key":"5_CR27","unstructured":"Li, J., et\u00a0al.: Can llm already serve as a database interface? a big bench for large-scale database grounded text-to-sqls. In: NeurIPS, pp. 42330\u201342357 (2023)"},{"key":"5_CR28","unstructured":"Liu, A., et\u00a0al.: Deepseek-v2: A strong, economical, and efficient mixture-of-experts language model. arXiv preprint arXiv:2405.04434 (2024)"},{"key":"5_CR29","unstructured":"Liu, X., Tan, Z.: Divide and prompt: Chain of thought prompting for text-to-sql. arXiv preprint arXiv:2304.11556 (2023)"},{"key":"5_CR30","unstructured":"Pourreza, M., Rafiei, D.: Din-sql: Decomposed in-context learning of text-to-sql with self-correction. In: NeurIPS (2024)"},{"key":"5_CR31","doi-asserted-by":"crossref","unstructured":"Pourreza, M., Rafiei, D.: Dts-sql: Decomposed text-to-sql with small large language models. In: Findings of EMNLP (2024)","DOI":"10.18653\/v1\/2024.findings-emnlp.481"},{"key":"5_CR32","unstructured":"Pourreza, M., et\u00a0al.: Chase-sql: Multi-path reasoning and preference optimized candidate selection in text-to-sql. arXiv preprint arXiv:2410.01943 (2024)"},{"key":"5_CR33","doi-asserted-by":"crossref","unstructured":"Ren, T., et\u00a0al.: Purple: Making a large language model a better sql writer. In: ICDE (2024)","DOI":"10.1109\/ICDE60146.2024.00009"},{"key":"5_CR34","unstructured":"Sui, G., et al.: Reboost large language model-based text-to-sql, text-to-python, and text-to-function\u2013with real applications in traffic domain. In: CORR (2023)"},{"key":"5_CR35","unstructured":"Sun, R., et\u00a0al.: Sql-palm: Improved large language model adaptation for text-to-sql (extended). arXiv preprint arXiv:2306.00739 (2023)"},{"key":"5_CR36","doi-asserted-by":"crossref","unstructured":"Tai, C.Y., Chen, Z., Zhang, T., Deng, X., Sun, H.: Exploring chain-of-thought style prompting for text-to-sql. In: EMNLP (2023)","DOI":"10.18653\/v1\/2023.emnlp-main.327"},{"key":"5_CR37","unstructured":"Talaei, S., Pourreza, M., Chang, Y.C., Mirhoseini, A., Saberi, A.: Chess: Contextual harnessing for efficient sql synthesis. arXiv preprint arXiv:2405.16755 (2024)"},{"key":"5_CR38","doi-asserted-by":"crossref","unstructured":"Wang, B., et\u00a0al.: Rat-sql: Relation-aware schema encoding and linking for text-to-sql parsers. In: ACL (2019)","DOI":"10.18653\/v1\/2020.acl-main.677"},{"key":"5_CR39","unstructured":"Wang, B., et\u00a0al.: Mac-sql: A multi-agent collaborative framework for text-to-sql. In: COLING (2025)"},{"key":"5_CR40","unstructured":"Wang, T., et\u00a0al.: Dbcopilot: Scaling natural language querying to massive databases. arXiv preprint arXiv:2312.03463 (2023)"},{"key":"5_CR41","doi-asserted-by":"crossref","unstructured":"Xie, Y., et\u00a0al.: Decomposition for enhancing attention: Improving llm-based text-to-sql through workflow paradigm. In: Findings of ACL (2024)","DOI":"10.18653\/v1\/2024.findings-acl.641"},{"key":"5_CR42","doi-asserted-by":"crossref","unstructured":"Zhang, H., et\u00a0al.: Act-sql: In-context learning for text-to-sql with automatically-generated chain-of-thought. In: ACL (2023)","DOI":"10.18653\/v1\/2023.findings-emnlp.227"},{"key":"5_CR43","unstructured":"Zhang, Q., Dong, J., Chen, H., Li, W., Huang, F., Huang, X.: Structure guided large language model for sql generation. arXiv preprint arXiv:2402.13284 (2024)"},{"key":"5_CR44","unstructured":"Zhang, T., et\u00a0al.: Sqlfuse: Enhancing text-to-sql performance through comprehensive llm synergy. arXiv preprint arXiv:2407.14568 (2024)"},{"key":"5_CR45","unstructured":"Zhao, Y., et\u00a0al.: Importance of synthesizing high-quality data for text-to-sql parsing. In: Findings of ACL (2023)"}],"container-title":["Lecture Notes in Computer Science","Web and Big Data"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-981-95-5716-5_5","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,1,22]],"date-time":"2026-01-22T13:07:11Z","timestamp":1769087231000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-981-95-5716-5_5"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2026]]},"ISBN":["9789819557158","9789819557165"],"references-count":45,"URL":"https:\/\/doi.org\/10.1007\/978-981-95-5716-5_5","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"value":"0302-9743","type":"print"},{"value":"1611-3349","type":"electronic"}],"subject":[],"published":{"date-parts":[[2026]]},"assertion":[{"value":"23 January 2026","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"APWeb-WAIM","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Asia-Pacific Web (APWeb) and Web-Age Information Management (WAIM) Joint International Conference on Web and Big Data","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Shenyang","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"China","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2025","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"28 August 2025","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"30 August 2025","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"9","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"apwebwaim2025","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/apweb2025.sau.edu.cn\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}