{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,31]],"date-time":"2025-10-31T07:02:00Z","timestamp":1761894120357,"version":"build-2065373602"},"publisher-location":"Singapore","reference-count":55,"publisher":"Springer Nature Singapore","isbn-type":[{"value":"9789819527243","type":"print"},{"value":"9789819527250","type":"electronic"}],"license":[{"start":{"date-parts":[[2025,11,1]],"date-time":"2025-11-01T00:00:00Z","timestamp":1761955200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2025,11,1]],"date-time":"2025-11-01T00:00:00Z","timestamp":1761955200000},"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-2725-0_26","type":"book-chapter","created":{"date-parts":[[2025,10,31]],"date-time":"2025-10-31T05:19:48Z","timestamp":1761887988000},"page":"435-468","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["DSMR-SQL: Enhancing Text-to-SQL with\u00a0Dual-Strategy SQL Generation and\u00a0Multi-role SQL Selection"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0009-0005-5003-2427","authenticated-orcid":false,"given":"Yiming","family":"Huang","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0001-7055-0767","authenticated-orcid":false,"given":"Jiyu","family":"Guo","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-4073-1214","authenticated-orcid":false,"given":"Jichuan","family":"Zeng","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-4774-2434","authenticated-orcid":false,"given":"Cuiyun","family":"Gao","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Peiyi","family":"Han","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Chuanyi","family":"Liu","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2025,11,1]]},"reference":[{"key":"26_CR1","doi-asserted-by":"crossref","unstructured":"Mendhe, D., Dogra, A., Nair, P.S., Punitha, S., Preetha, K.S., Tilak Babu, S.B.G.: AI-enabled data-driven approaches for personalized medicine and healthcare analytics. In: 2024 Ninth International Conference on Science Technology Engineering and Mathematics (ICONSTEM), pp. 1\u20135. IEEE (2024)","DOI":"10.1109\/ICONSTEM60960.2024.10568722"},{"key":"26_CR2","doi-asserted-by":"crossref","unstructured":"Zhang, C., et al.: FinSQL: model-agnostic LLMs-based text-to-SQL framework for financial analysis. In: Companion of the 2024 International Conference on Management of Data, pp. 93\u2013105 (2024)","DOI":"10.1145\/3626246.3653375"},{"key":"26_CR3","unstructured":"Deng, N., Chen, Y., Zhang, Y.: Recent advances in text-to-SQL: a survey of what we have and what we expect. In: Proceedings of the 29th International Conference on Computational Linguistics, pp. 2166\u20132187 (2022)"},{"key":"26_CR4","unstructured":"Achiam, J., et\u00a0al.: GPT-4 technical report. arXiv preprint arXiv:2303.08774 (2023)"},{"key":"26_CR5","unstructured":"Pourreza, M., Rafiei, D.: Din-SQL: decomposed in-context learning of text-to-SQL with self-correction. In: Advances in Neural Information Processing Systems, vol. 36 (2024)"},{"key":"26_CR6","doi-asserted-by":"crossref","unstructured":"Gao, D., et al.: Text-to-SQL empowered by large language models: a benchmark evaluation. In: International Conference on Very Large Data Bases (VLDB) (2024)","DOI":"10.14778\/3641204.3641221"},{"key":"26_CR7","unstructured":"Lee, D., Park, C., Kim, J., Park, H.: MCS-SQL: leveraging multiple prompts and multiple-choice selection for text-to-SQL generation. arXiv preprint arXiv:2405.07467 (2024)"},{"key":"26_CR8","doi-asserted-by":"crossref","unstructured":"Li, H., et al.: CodeS: towards building open-source language models for text-to-SQL. In: Proceedings of the ACM on Management of Data, vol. 2, no. 3, pp. 1\u201328 (2024)","DOI":"10.1145\/3654930"},{"key":"26_CR9","doi-asserted-by":"crossref","unstructured":"Pourreza, M., Rafiei, D.: DTS-SQL: decomposed text-to-SQL with small large language models. arXiv preprint arXiv:2402.01117 (2024)","DOI":"10.18653\/v1\/2024.findings-emnlp.481"},{"key":"26_CR10","doi-asserted-by":"crossref","unstructured":"Lu, Y., Bartolo, M., Moore, A., Riedel, S., Stenetorp, P.: Fantastically ordered prompts and where to find them: overcoming few-shot prompt order sensitivity. In: Proceedings of the 60th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers), pp. 8086\u20138098 (2022)","DOI":"10.18653\/v1\/2022.acl-long.556"},{"key":"26_CR11","doi-asserted-by":"crossref","unstructured":"Jang, M., Lukasiewicz, T.: Consistency analysis of chatGPT. In: Proceedings of the 2023 Conference on Empirical Methods in Natural Language Processing, pp. 15970\u201315985 (2023)","DOI":"10.18653\/v1\/2023.emnlp-main.991"},{"key":"26_CR12","doi-asserted-by":"crossref","unstructured":"Cheng, F., Zouhar, V., Arora, S., Sachan, M., Strobelt, H., El-Assady, M.: RELIC: investigating large language model responses using self-consistency. In: Proceedings of the CHI Conference on Human Factors in Computing Systems, pp. 1\u201318 (2024)","DOI":"10.1145\/3613904.3641904"},{"key":"26_CR13","doi-asserted-by":"crossref","unstructured":"Mao, W. et al.: Enhancing text-to-SQL parsing through question rewriting and execution-guided refinement. In Findings of the Association for Computational Linguistics ACL 2024, pp. 2009\u20132024 (2024)","DOI":"10.18653\/v1\/2024.findings-acl.120"},{"key":"26_CR14","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":"26_CR15","doi-asserted-by":"crossref","unstructured":"Renze, M., Guven, E.: The effect of sampling temperature on problem solving in large language models. arXiv preprint arXiv:2402.05201 (2024)","DOI":"10.18653\/v1\/2024.findings-emnlp.432"},{"issue":"12","key":"26_CR16","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/3571730","volume":"55","author":"Z Ji","year":"2023","unstructured":"Ji, Z., et al.: Survey of hallucination in natural language generation. ACM Comput. Surv. 55(12), 1\u201338 (2023)","journal-title":"ACM Comput. Surv."},{"key":"26_CR17","doi-asserted-by":"crossref","unstructured":"Yin, Z., Sun, Q., Guo, Q., Jiawen, W., Qiu, X., Huang, X.-J.: Do large language models know what they don\u2019t know? In Findings of the Association for Computational Linguistics: ACL 2023, pp. 8653\u20138665 (2023)","DOI":"10.18653\/v1\/2023.findings-acl.551"},{"key":"26_CR18","unstructured":"Jiang, J., Wang, F., Shen, J., Kim, S., Kim, S.: A survey on large language models for code generation. arXiv preprint arXiv:2406.00515 (2024)"},{"key":"26_CR19","doi-asserted-by":"crossref","unstructured":"Jiang, W., Han, J., Liu, H., Tao, T., Tan, N., Xiong, H.: Interpretable cascading mixture-of-experts for urban traffic congestion prediction. In: Proceedings of the 30th ACM SIGKDD Conference on Knowledge Discovery and Data Mining, pp. 5206\u20135217 (2024)","DOI":"10.1145\/3637528.3671507"},{"key":"26_CR20","unstructured":"Liu, A., Hu, X., Wen, L., Yu, P.S.: A comprehensive evaluation of chatGPT\u2019s zero-shot text-to-SQL capability. arXiv preprint arXiv:2303.13547 (2023)"},{"key":"26_CR21","unstructured":"Li, Z., Xie, T.: Using LLM to select the right SQL query from candidates. arXiv preprint arXiv:2401.02115 (2024)"},{"key":"26_CR22","unstructured":"Pourreza, M., et al.: Chase-SQL: multi-path reasoning and preference optimized candidate selection in text-to-SQL. arXiv preprint arXiv:2410.01943 (2024)"},{"key":"26_CR23","unstructured":"Wang, P., et al.: Large language models are not fair evaluators. arXiv preprint arXiv:2305.17926 (2023)"},{"key":"26_CR24","unstructured":"Shi, L., Ma, C., Liang, W., Ma, W., Vosoughi, S.: Judging the judges: a systematic investigation of position bias in pairwise comparative assessments by LLMs. arXiv preprint arXiv:2406.07791 (2024)"},{"key":"26_CR25","doi-asserted-by":"crossref","unstructured":"Zhang, H., Zhang, R., Guo, J., de\u00a0Rijke, M., Fan, Y., Cheng, X.: Are large language models good at utility judgments? In: Proceedings of the 47th International ACM SIGIR Conference on Research and Development in Information Retrieval, pp. 1941\u20131951 (2024)","DOI":"10.1145\/3626772.3657784"},{"key":"26_CR26","doi-asserted-by":"crossref","unstructured":"Zheng, L., et al.: Reverse multi-choice dialogue commonsense inference with graph-of-thought. In: Proceedings of the AAAI Conference on Artificial Intelligence, vol. 38, pp. 19688\u201319696 (2024)","DOI":"10.1609\/aaai.v38i17.29942"},{"key":"26_CR27","unstructured":"Madaan, A., et\u00a0al.: Self-refine: iterative refinement with self-feedback. In: Advances in Neural Information Processing Systems, vol. 36 (2024)"},{"key":"26_CR28","unstructured":"Wang, B., et\u00a0al.: Mac-SQL: a multi-agent collaborative framework for text-to-SQL. arXiv preprint arXiv:2312.11242 (2024)"},{"key":"26_CR29","unstructured":"Turpin, M., Michael, J., Perez, E., Bowman, S.: Language models don\u2019t always say what they think: unfaithful explanations in chain-of-thought prompting. In: Advances in Neural Information Processing Systems, vol. 36 (2024)"},{"key":"26_CR30","unstructured":"Dong, X., et\u00a0al.: C3: zero-shot text-to-SQL with chatGPT. arXiv preprint arXiv:2307.0730 (2023)"},{"key":"26_CR31","doi-asserted-by":"crossref","unstructured":"Fan, Y., et al.: MetaSQL: a generate-then-rank framework for natural language to SQL translation. In: 40th IEEE International Conference on Data Engineering, ICDE 2024, pp. 1765\u20131778 (2024)","DOI":"10.1109\/ICDE60146.2024.00143"},{"key":"26_CR32","doi-asserted-by":"crossref","unstructured":"Ren, T., et al.: Purple: Making a large language model a better SQL writer. In: 2024 IEEE 40th International Conference on Data Engineering (ICDE), pp. 15\u201328 (2024)","DOI":"10.1109\/ICDE60146.2024.00009"},{"key":"26_CR33","unstructured":"Ni, A., et al.: Lever: learning to verify language-to-code generation with execution. In: International Conference on Machine Learning, pp. 26106\u201326128. PMLR (2023)"},{"key":"26_CR34","unstructured":"Qi, Z., Ma, M., Xu, J., Zhang, L.L., Yang, F., Yang, M.: Mutual reasoning makes smaller LLMs stronger problem-solvers. arXiv preprint arXiv:2408.06195 (2024)"},{"key":"26_CR35","unstructured":"Lin, B.Y., et al.: SwiftSage: a generative agent with fast and slow thinking for complex interactive tasks. In: Advances in Neural Information Processing Systems, vol. 36 (2024)"},{"key":"26_CR36","doi-asserted-by":"crossref","unstructured":"Liang, T., et al.: Encouraging divergent thinking in large language models through multi-agent debate. arXiv preprint arXiv:2305.19118 (2023)","DOI":"10.18653\/v1\/2024.emnlp-main.992"},{"key":"26_CR37","doi-asserted-by":"crossref","unstructured":"Xie, Y., et al.: Decomposition for enhancing attention: improving LLM-based text-to-SQL through workflow paradigm. In: Findings of the Association for Computational Linguistics, ACL 2024, pp. 10796\u201310816 (2024)","DOI":"10.18653\/v1\/2024.findings-acl.641"},{"key":"26_CR38","doi-asserted-by":"crossref","unstructured":"Ge, Q., et al.: Before generation, align it! A novel and effective strategy for mitigating hallucinations in text-to-SQL generation. In: Findings of the Association for Computational Linguistics, ACL 2024, pp. 5456\u20135471 (2024)","DOI":"10.18653\/v1\/2024.findings-acl.324"},{"key":"26_CR39","unstructured":"Xie, W., Wu, G., Zhou, B.: Mag-SQL: multi-agent generative approach with soft schema linking and iterative sub-SQL refinement for text-to-SQL. arXiv preprint arXiv:2408.07930 (2024)"},{"key":"26_CR40","doi-asserted-by":"crossref","unstructured":"Luo, R., Wang, L., Lin, B., Lin, Z., Yang, Y.: PTD-SQL: partitioning and targeted drilling with LLMs in text-to-SQL. arXiv preprint arXiv:2409.14082 (2024)","DOI":"10.18653\/v1\/2024.emnlp-main.221"},{"key":"26_CR41","doi-asserted-by":"crossref","unstructured":"Yang, J., Hui, B., Yang, M., Yang, J., Lin, J., Zhou, C.: Synthesizing text-to-SQL data from weak and strong LLMs. In: Proceedings of the 62nd Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers), pp. 7864\u20137875 (2024)","DOI":"10.18653\/v1\/2024.acl-long.425"},{"key":"26_CR42","doi-asserted-by":"crossref","unstructured":"Yu, T., et\u00a0al.: Spider: a large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-SQL task. In: Proceedings of the 2018 Conference on Empirical Methods in Natural Language Processing, pp. 3911\u20133921 (2018)","DOI":"10.18653\/v1\/D18-1425"},{"key":"26_CR43","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: Advances in Neural Information Processing Systems, vol. 36 (2024)"},{"key":"26_CR44","doi-asserted-by":"crossref","unstructured":"Gan, Y., Chen, X., Purver, M.: Exploring underexplored limitations of cross-domain text-to-SQL generalization. In: Proceedings of the 2021 Conference on Empirical Methods in Natural Language Processing, pp. 8926\u20138931 (2021)","DOI":"10.18653\/v1\/2021.emnlp-main.702"},{"key":"26_CR45","doi-asserted-by":"crossref","unstructured":"Deng, X., Awadallah, A.H., Meek, C., Polozov, O., Sun, H., Richardson, M.: Structure-grounded pretraining for text-to-SQL. In: Proceedings of the 2021 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies, NAACL-HLT 2021, pp. 1337\u20131350 (2021)","DOI":"10.18653\/v1\/2021.naacl-main.105"},{"key":"26_CR46","doi-asserted-by":"crossref","unstructured":"Gan, Y., et al.: Towards robustness of text-to-SQL models against synonym substitution. In: Proceedings of the 59th Annual Meeting of the Association for Computational Linguistics and the 11th International Joint Conference on Natural Language Processing, ACL\/IJCNLP 2021, pp. 2505\u20132515 (2021)","DOI":"10.18653\/v1\/2021.acl-long.195"},{"key":"26_CR47","unstructured":"Touvron, H., et\u00a0al.: LLaMA 2: open foundation and fine-tuned chat models. arXiv preprint arXiv:2307.09288 (2023)"},{"key":"26_CR48","unstructured":"Pinnaparaju, N., et\u00a0al.: Stable code technical report. arXiv preprint arXiv:2404.01226 (2024)"},{"key":"26_CR49","unstructured":"Hurst, A., et\u00a0al.: GPT-4o system card. arXiv preprint arXiv:2410.21276 (2024)"},{"key":"26_CR50","unstructured":"Team, G., et\u00a0al.: Gemini 1.5: unlocking multimodal understanding across millions of tokens of context. arXiv preprint arXiv:2403.05530 (2024)"},{"key":"26_CR51","doi-asserted-by":"crossref","unstructured":"Zhong, R., Yu, T., Klein, D.: Semantic evaluation for text-to-SQL with distilled test suites. In: Proceedings of the 2020 Conference on Empirical Methods in Natural Language Processing, EMNLP 2020, pp. 396\u2013411 (2020)","DOI":"10.18653\/v1\/2020.emnlp-main.29"},{"key":"26_CR52","unstructured":"Liu, X., et al.: A survey of NL2SQL with large language models: where are we, and where are we going? arXiv preprint arXiv:2408.05109 (2024)"},{"key":"26_CR53","unstructured":"Paszke, A., et\u00a0al. PyTorch: an imperative style, high-performance deep learning library. In: Advances in Neural Information Processing Systems, vol. 32 (2019)"},{"key":"26_CR54","doi-asserted-by":"crossref","unstructured":"Zhou, P., Xie, X., Lin, Z., Yan, S.: Towards understanding convergence and generalization of AdamW. IEEE Trans. Pattern Anal. Mach. Intell. (2024)","DOI":"10.1109\/TPAMI.2024.3382294"},{"key":"26_CR55","unstructured":"Zhou, D., et\u00a0al.: Least-to-most prompting enables complex reasoning in large language models. In: The Eleventh International Conference on Learning Representations (2022)"}],"container-title":["Lecture Notes in Computer Science","Chinese Computational Linguistics"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-981-95-2725-0_26","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,31]],"date-time":"2025-10-31T05:20:12Z","timestamp":1761888012000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-981-95-2725-0_26"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,11,1]]},"ISBN":["9789819527243","9789819527250"],"references-count":55,"URL":"https:\/\/doi.org\/10.1007\/978-981-95-2725-0_26","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"value":"0302-9743","type":"print"},{"value":"1611-3349","type":"electronic"}],"subject":[],"published":{"date-parts":[[2025,11,1]]},"assertion":[{"value":"1 November 2025","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"CCL","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"China National Conference on Chinese Computational Linguistics","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Jinan","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":"11 August 2025","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"14 August 2025","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"24","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"cncl2025","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/link.springer.com\/conference\/cncl","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}