{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,9]],"date-time":"2026-07-09T06:23:11Z","timestamp":1783578191374,"version":"3.55.0"},"reference-count":31,"publisher":"Springer Science and Business Media LLC","issue":"4","license":[{"start":{"date-parts":[[2026,2,24]],"date-time":"2026-02-24T00:00:00Z","timestamp":1771891200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2026,2,24]],"date-time":"2026-02-24T00:00:00Z","timestamp":1771891200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"}],"funder":[{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation of China","doi-asserted-by":"publisher","award":["N2317005"],"award-info":[{"award-number":["N2317005"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["J Intell Inf Syst"],"published-print":{"date-parts":[[2026,8]]},"DOI":"10.1007\/s10844-026-01032-z","type":"journal-article","created":{"date-parts":[[2026,2,24]],"date-time":"2026-02-24T04:37:13Z","timestamp":1771907833000},"page":"1531-1555","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":2,"title":["Enhancing SQL generation through high-quality logical guidance"],"prefix":"10.1007","volume":"64","author":[{"given":"Zhe","family":"Zhang","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Yuming","family":"Chen","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Chaopeng","family":"Guo","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Jie","family":"Song","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"297","published-online":{"date-parts":[[2026,2,24]]},"reference":[{"key":"1032_CR1","doi-asserted-by":"publisher","unstructured":"Deng, X., Hassan, A., Meek, C., et al. (2021). 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 (pp. 337\u20131350). https:\/\/doi.org\/10.18653\/v1\/2021.naacl-main.105","DOI":"10.18653\/v1\/2021.naacl-main.105"},{"key":"1032_CR2","doi-asserted-by":"publisher","unstructured":"Devlin, J., Chang, M. W., Lee, K., et al. (2019). Bert: Pre-training of deep bidirectional transformers for language understanding. In Proceedings of the 2019 conference of the North American chapter of the association for computational linguistics: Human language technologies (pp. 4171\u20134186). https:\/\/doi.org\/10.18653\/v1\/N19-1423","DOI":"10.18653\/v1\/N19-1423"},{"key":"1032_CR3","doi-asserted-by":"publisher","unstructured":"Dong, X., Zhang, C., Ge, Y., et al. (2023). C3: Zero-shot text-to-sql with chatgpt. arXiv:2307.07306. https:\/\/doi.org\/10.48550\/arXiv.2307.07306","DOI":"10.48550\/arXiv.2307.07306"},{"key":"1032_CR4","doi-asserted-by":"publisher","unstructured":"Gan, Y., Chen, X., Huang, Q., et al. (2021a). Towards robustness of text-to-sql models against synonym substitution. arXiv:2106.01065. https:\/\/doi.org\/10.48550\/arXiv.2106.01065","DOI":"10.48550\/arXiv.2106.01065"},{"key":"1032_CR5","doi-asserted-by":"publisher","unstructured":"Gan, Y., Chen, X., & Purver, M. (2021b). 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). https:\/\/doi.org\/10.18653\/v1\/2021.emnlp-main.702","DOI":"10.18653\/v1\/2021.emnlp-main.702"},{"key":"1032_CR6","doi-asserted-by":"publisher","unstructured":"Gan, Y., Chen, X., Xie, J., et al. (2021c). Natural sql: Making sql easier to infer from natural language specifications. In Findings of the association for computational linguistics: EMNLP 2021 (pp. 2030\u20132042). https:\/\/doi.org\/10.18653\/v1\/2021.findings-emnlp.174","DOI":"10.18653\/v1\/2021.findings-emnlp.174"},{"key":"1032_CR7","doi-asserted-by":"publisher","unstructured":"Gao, D., Wang, H., Li, Y., et al. (2024). Text-to-sql empowered by large language models: A benchmark evaluation. Proceedings of the VLDB Endowment, 17(5), 1132\u20131145. https:\/\/doi.org\/10.14778\/3641204.3641221","DOI":"10.14778\/3641204.3641221"},{"issue":"2","key":"1032_CR8","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/3589292","volume":"1","author":"Z Gu","year":"2023","unstructured":"Gu, Z., Fan, J., Tang, N., et al. (2023). Few-shot text-to-sql translation using structure and content prompt learning. Proceedings of the ACM on Management of Data, 1(2), 1\u201328. https:\/\/doi.org\/10.1145\/3589292","journal-title":"Proceedings of the ACM on Management of Data"},{"key":"1032_CR9","doi-asserted-by":"publisher","unstructured":"Guo, J., Zhan, Z., Gao, Y., et al. (2019). Towards complex text-to-sql in cross-domain database with intermediate representation. In Proceedings of the 57th annual meeting of the association for computational linguistics. Association for Computational Linguistics. https:\/\/doi.org\/10.18653\/v1\/P19-1444","DOI":"10.18653\/v1\/P19-1444"},{"key":"1032_CR10","doi-asserted-by":"publisher","unstructured":"Lei, W., Wang, W., Ma, Z., et al. (2020). Re-examining the role of schema linking in text-to-sql. In Proceedings of the 2020 conference on empirical methods in natural language processing (EMNLP) (pp. 6943\u20136954). https:\/\/doi.org\/10.18653\/v1\/2020.emnlp-main.564","DOI":"10.18653\/v1\/2020.emnlp-main.564"},{"key":"1032_CR11","doi-asserted-by":"publisher","unstructured":"Li, H., Zhang, J., Li, C., et al. (2023a). Resdsql: Decoupling schema linking and skeleton parsing for text-to-sql. In Proceedings of the AAAI conference on artificial intelligence (pp. 13067\u201313075). https:\/\/doi.org\/10.1609\/aaai.v37i11.26535","DOI":"10.1609\/aaai.v37i11.26535"},{"issue":"3","key":"1032_CR12","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/3654930","volume":"2","author":"H Li","year":"2024","unstructured":"Li, H., Zhang, J., Liu, H., et al. (2024). Codes: Towards building open-source language models for text-to-sql. Proceedings of the ACM on Management of Data, 2(3), 1\u201328. https:\/\/doi.org\/10.1145\/3654930","journal-title":"Proceedings of the ACM on Management of Data"},{"key":"1032_CR13","doi-asserted-by":"publisher","unstructured":"Li, J., Hui, B., Cheng, R., et al. (2023b). Graphix-t5: Mixing pre-trained transformers with graph-aware layers for text-to-sql parsing. In Proceedings of the AAAI conference on artificial intelligence (pp. 13076\u201313084). https:\/\/doi.org\/10.1609\/aaai.v37i11.26536","DOI":"10.1609\/aaai.v37i11.26536"},{"key":"1032_CR14","doi-asserted-by":"publisher","unstructured":"Lin, X. V., Socher, R., & Xiong, C. (2020). Bridging textual and tabular data for cross-domain text-to-sql semantic parsing. In Findings of EMNLP 2020 (pp. 4870\u20134888). https:\/\/doi.org\/10.18653\/v1\/2020.findings-emnlp.438","DOI":"10.18653\/v1\/2020.findings-emnlp.438"},{"key":"1032_CR15","doi-asserted-by":"publisher","unstructured":"Liu, A., Hu, X., Lin, L., et al. (2022). Semantic enhanced text-to-sql parsing via iteratively learning schema linking graph. In Proceedings of the 28th ACM SIGKDD conference on knowledge discovery and data mining (pp. 1021\u20131030). https:\/\/doi.org\/10.1145\/3534678.3539294","DOI":"10.1145\/3534678.3539294"},{"key":"1032_CR16","doi-asserted-by":"publisher","unstructured":"Loshchilov, I., & Hutter, F. (2017). Decoupled weight decay regularization. arXiv:1711.05101. https:\/\/doi.org\/10.48550\/arXiv.1711.05101","DOI":"10.48550\/arXiv.1711.05101"},{"key":"1032_CR17","doi-asserted-by":"publisher","unstructured":"Nan, L., Zhao, Y., Zou, W., et al. (2023). Enhancing text-to-sql capabilities of large language models: A study on prompt design strategies. In Findings of the association for computational linguistics: EMNLP 2023 (pp. 14935\u201314956). https:\/\/doi.org\/10.18653\/v1\/2023.findings-emnlp.996","DOI":"10.18653\/v1\/2023.findings-emnlp.996"},{"key":"1032_CR18","doi-asserted-by":"publisher","unstructured":"Pourreza, M., & Rafiei, D. (2024). Din-sql: Decomposed in-context learning of text-to-sql with self-correction. Advances in Neural Information Processing Systems, 36. https:\/\/doi.org\/10.48550\/arXiv.2304.11015","DOI":"10.48550\/arXiv.2304.11015"},{"key":"1032_CR19","doi-asserted-by":"publisher","unstructured":"Rubin, O., & Berant, J. (2021). SmBoP: Semi-autoregressive bottom-up semantic parsing. In Toutanova, K., Rumshisky, A., Zettlemoyer, L., et al. (Eds.), Proceedings of the 2021 conference of the North American chapter of the association for computational linguistics: Human language technologies (pp. 311\u2013324). https:\/\/doi.org\/10.18653\/v1\/2021.naacl-main.29","DOI":"10.18653\/v1\/2021.naacl-main.29"},{"key":"1032_CR20","doi-asserted-by":"publisher","unstructured":"Scholak, T., Schucher, N., & Bahdanau, D. (2021). Picard: Parsing incrementally for constrained autoregressive decoding from language models. In Proceedings of the 2021 conference on empirical methods in natural language processing (EMNLP) (pp. 9895\u20139901). https:\/\/doi.org\/10.18653\/v1\/2021.emnlp-main.779","DOI":"10.18653\/v1\/2021.emnlp-main.779"},{"key":"1032_CR21","doi-asserted-by":"publisher","unstructured":"Shen, C., Wang, J., Rahman, S., et al. (2025). Magesql: Enhancing in-context learning for text-to-sql applications with large language models. arXiv:2504.02055. https:\/\/doi.org\/10.48550\/arXiv.2504.02055","DOI":"10.48550\/arXiv.2504.02055"},{"key":"1032_CR22","doi-asserted-by":"publisher","unstructured":"Shen, Z., Vougiouklis, P., Diao, C., et al. (2024). Improving retrieval-augmented text-to-sql with ast-based ranking and schema pruning. In Proceedings of the 2024 conference on empirical methods in natural language processing (pp. 7865\u20137879). https:\/\/doi.org\/10.48550\/arXiv.2407.03227","DOI":"10.48550\/arXiv.2407.03227"},{"key":"1032_CR23","doi-asserted-by":"publisher","unstructured":"Shi, P., Ng, P., Wang, Z., et al. (2021). Learning contextual representations for semantic parsing with generation-augmented pre-training. In Proceedings of the AAAI conference on artificial intelligence (pp. 13806\u201313814). https:\/\/doi.org\/10.1609\/aaai.v35i15.17627","DOI":"10.1609\/aaai.v35i15.17627"},{"key":"1032_CR24","doi-asserted-by":"publisher","unstructured":"Sun, R., Arik, S. \u00d6., Muzio, A., et al. (2023). Sql-palm: Improved large language model adaptation for text-to-sql (extended). arXiv:2306.00739. https:\/\/doi.org\/10.48550\/arXiv.2306.00739","DOI":"10.48550\/arXiv.2306.00739"},{"key":"1032_CR25","doi-asserted-by":"publisher","unstructured":"Vaswani, A., Shazeer, N., Parmar, N., et al. (2017). Attention is all you need. In Advances in neural information processing systems. https:\/\/doi.org\/10.48550\/arXiv.1706.03762","DOI":"10.48550\/arXiv.1706.03762"},{"key":"1032_CR26","doi-asserted-by":"publisher","unstructured":"Xie, T., Wu, C. H., Shi, P., et al. (2022). Unifiedskg: Unifying and multi-tasking structured knowledge grounding with text-to-text language models. In Proceedings of the 2022 conference on empirical methods in natural language processing (pp. 602\u2013631). https:\/\/doi.org\/10.18653\/v1\/2022.emnlp-main.39","DOI":"10.18653\/v1\/2022.emnlp-main.39"},{"key":"1032_CR27","doi-asserted-by":"publisher","unstructured":"Xie, W., Wu, G., & Zhou, B. (2024). Mag-sql: Multi-agent generative approach with soft schema linking and iterative sub-sql refinement for text-to-sql. arXiv:2408.07930. https:\/\/doi.org\/10.48550\/arXiv.2408.07930","DOI":"10.48550\/arXiv.2408.07930"},{"issue":"5","key":"1032_CR28","doi-asserted-by":"publisher","first-page":"1779","DOI":"10.1007\/s10844-025-00963-3","volume":"63","author":"J Yi","year":"2025","unstructured":"Yi, J., & Chen, G. (2025). Skt-sql: multi-decoupling and skeleton prompt framework for text-to-sql on small-scale lms. Journal of Intelligent Information Systems, 63(5), 1779\u20131805. https:\/\/doi.org\/10.1007\/s10844-025-00963-3","journal-title":"Journal of Intelligent Information Systems"},{"key":"1032_CR29","doi-asserted-by":"publisher","unstructured":"Yu, T., Zhang, R., Yang, K., 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. https:\/\/doi.org\/10.48550\/arXiv.1809.08887","DOI":"10.48550\/arXiv.1809.08887"},{"key":"1032_CR30","doi-asserted-by":"publisher","unstructured":"Yu, T., Wu, C. S., Lin, X. V., et al. (2020). Grappa: Grammar-augmented pre-training for table semantic parsing. arXiv:2009.13845. https:\/\/doi.org\/10.48550\/arXiv.2009.13845","DOI":"10.48550\/arXiv.2009.13845"},{"key":"1032_CR31","doi-asserted-by":"publisher","unstructured":"Zhang, H., Cao, R., Chen, L., et al. (2023). Act-sql: In-context learning for text-to-sql with automatically-generated chain-of-thought. In The 2023 conference on empirical methods in natural language processing. https:\/\/doi.org\/10.48550\/arXiv.2310.17342","DOI":"10.48550\/arXiv.2310.17342"}],"container-title":["Journal of Intelligent Information Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10844-026-01032-z.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s10844-026-01032-z","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10844-026-01032-z.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,7,9]],"date-time":"2026-07-09T06:09:26Z","timestamp":1783577366000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s10844-026-01032-z"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2026,2,24]]},"references-count":31,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2026,8]]}},"alternative-id":["1032"],"URL":"https:\/\/doi.org\/10.1007\/s10844-026-01032-z","relation":{},"ISSN":["0925-9902","1573-7675"],"issn-type":[{"value":"0925-9902","type":"print"},{"value":"1573-7675","type":"electronic"}],"subject":[],"published":{"date-parts":[[2026,2,24]]},"assertion":[{"value":"28 August 2025","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"5 February 2026","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"6 February 2026","order":3,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"24 February 2026","order":4,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}},{"order":1,"name":"Ethics","group":{"name":"EthicsHeading","label":"Declarations"}},{"value":"This article does not contain any studies with human participants or animals performed by any of the authors. Informed consent was obtained from all the individual participants included in the study. The authors declare that they have no conflict of interest.","order":2,"name":"Ethics","group":{"name":"EthicsHeading","label":"Conflict of interest"}},{"value":"The authors declare no competing interests.","order":3,"name":"Ethics","group":{"name":"EthicsHeading","label":"Competing interests"}}]}}