{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,4]],"date-time":"2026-07-04T05:16:38Z","timestamp":1783142198728,"version":"3.54.6"},"reference-count":41,"publisher":"Elsevier BV","license":[{"start":{"date-parts":[[2026,12,1]],"date-time":"2026-12-01T00:00:00Z","timestamp":1796083200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"},{"start":{"date-parts":[[2026,12,1]],"date-time":"2026-12-01T00:00:00Z","timestamp":1796083200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/legal\/tdmrep-license"},{"start":{"date-parts":[[2026,12,1]],"date-time":"2026-12-01T00:00:00Z","timestamp":1796083200000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-017"},{"start":{"date-parts":[[2026,12,1]],"date-time":"2026-12-01T00:00:00Z","timestamp":1796083200000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-037"},{"start":{"date-parts":[[2026,12,1]],"date-time":"2026-12-01T00:00:00Z","timestamp":1796083200000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-012"},{"start":{"date-parts":[[2026,12,1]],"date-time":"2026-12-01T00:00:00Z","timestamp":1796083200000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-029"},{"start":{"date-parts":[[2026,12,1]],"date-time":"2026-12-01T00:00:00Z","timestamp":1796083200000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-004"}],"funder":[{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation of China","doi-asserted-by":"publisher","award":["62506077"],"award-info":[{"award-number":["62506077"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation of China","doi-asserted-by":"publisher","award":["72201061"],"award-info":[{"award-number":["72201061"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation of China","doi-asserted-by":"publisher","award":["72271233"],"award-info":[{"award-number":["72271233"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["elsevier.com","sciencedirect.com"],"crossmark-restriction":true},"short-container-title":["Expert Systems with Applications"],"published-print":{"date-parts":[[2026,12]]},"DOI":"10.1016\/j.eswa.2026.133067","type":"journal-article","created":{"date-parts":[[2026,5,30]],"date-time":"2026-05-30T15:34:15Z","timestamp":1780155255000},"page":"133067","update-policy":"https:\/\/doi.org\/10.1016\/elsevier_cm_policy","source":"Crossref","is-referenced-by-count":0,"special_numbering":"PA","title":["Enhanced financial text-to-SQL generation via fine-grained SQL refinement"],"prefix":"10.1016","volume":"331","author":[{"ORCID":"https:\/\/orcid.org\/0009-0003-0113-8466","authenticated-orcid":false,"given":"Yihan","family":"Wang","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0006-1136-096X","authenticated-orcid":false,"given":"Yunjun","family":"Chen","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-2974-9184","authenticated-orcid":false,"given":"Peiyu","family":"Liu","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0009-5584-7341","authenticated-orcid":false,"given":"Huiyan","family":"Shu","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-2704-8293","authenticated-orcid":false,"given":"Runyu","family":"Chen","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-7992-9063","authenticated-orcid":false,"given":"Wei","family":"Xu","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"78","reference":[{"key":"10.1016\/j.eswa.2026.133067_bib0001","article-title":"RSL-SQL: Robust schema linking in text-to-sql generation","volume":"abs\/2411.00073","author":"Cao","year":"2024","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0002","series-title":"Aaai-25, sponsored by the association for the advancement of artificial intelligence, february 25, - march 4, 2025, philadelphia, pa, USA","first-page":"49","article-title":"Sqlfixagent: Towards semantic-accurate text-to-sql parsing via consistency-enhanced multi-agent collaboration","author":"Cen","year":"2025"},{"key":"10.1016\/j.eswa.2026.133067_bib0003","article-title":"RefoRCE: A text-to-SQL agent with self-refinement, format restriction, and column exploration","volume":"abs\/2502.00675","author":"Deng","year":"2025","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0004","article-title":"UniSAr: A unified structure-aware autoregressive language model for text-to-SQL","volume":"abs\/2203.07781","author":"Dou","year":"2022","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0005","article-title":"Text-to-SQL empowered by large language models: A benchmark evaluation","volume":"abs\/2308.15363","author":"Gao","year":"2023","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0006","series-title":"Proceedings of the 57th conference of the association for computational linguistics, ACL 2019, florence, italy, july 28- august 2, 2019, volume 1: Long papers","first-page":"4524","article-title":"Towards complex text-to-SQL in cross-domain database with intermediate representation","author":"Guo","year":"2019"},{"key":"10.1016\/j.eswa.2026.133067_bib0007","series-title":"Speech and natural language: Proceedings of a workshop held at hidden valley, pennsylvania, june 24\u201327, 1990","article-title":"The ATIS spoken language systems pilot corpus","author":"Hemphill","year":"1990"},{"issue":"12","key":"10.1016\/j.eswa.2026.133067_bib0008","doi-asserted-by":"crossref","first-page":"7328","DOI":"10.1109\/TKDE.2025.3609486","article-title":"Next-generation database interfaces: A survey of LLM-based text-to-SQL","volume":"37","author":"Hong","year":"2025","journal-title":"IEEE Transactions on Knowledge and Data Engineering"},{"key":"10.1016\/j.eswa.2026.133067_bib0009","article-title":"Finai data assistant: Llm-based financial database query processing with the openai function calling API","volume":"abs\/2510.14162","author":"Kim","year":"2025","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0010","article-title":"BookSQL: A large scale text-to-SQL dataset for accounting domain","volume":"abs\/2406.07860","author":"Kumar","year":"2024","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0011","series-title":"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, (volume 1: Long papers), virtual event, august 1\u20136, 2021","first-page":"2261","article-title":"KaggleDBQA: Realistic evaluation of text-to-SQL parsers","author":"Lee","year":"2021"},{"issue":"1","key":"10.1016\/j.eswa.2026.133067_sbref0012","doi-asserted-by":"crossref","first-page":"73","DOI":"10.14778\/2735461.2735468","article-title":"Constructing an interactive natural language interface for relational databases","volume":"8","author":"Li","year":"2014","journal-title":"Proceedings of the VLDB Endowment"},{"key":"10.1016\/j.eswa.2026.133067_bib0013","article-title":"RESDSQL: Decoupling schema linking and skeleton parsing for text-to-sql","volume":"abs\/2302.05965","author":"Li","year":"2023","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0014","article-title":"Graphix-t5: Mixing pre-trained transformers with graph-aware layers for text-to-SQL parsing","volume":"abs\/2301.07507","author":"Li","year":"2023","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_sbref0015","series-title":"Advances in neural information processing systems 36: annual conference on neural information processing systems 2023, neurIPS 2023, new orleans, LA, USA, december 10, - 16, 2023","article-title":"Can LLM already serve as a database interface? a big bench for large-scale database grounded text-to-sqls","author":"Li","year":"2023"},{"key":"10.1016\/j.eswa.2026.133067_bib0016","doi-asserted-by":"crossref","unstructured":"Liao, H., Chen, S., Xiao, Y., Xiang, L., & Min, F.. Large-scale text-to-SQL generation with adversarial defense. 733: ISSN 0020\u20130255, 122942. https:\/\/www.sciencedirect.com\/science\/article\/pii\/S0020025525010795. 10.1016\/j.ins.2025.122942.","DOI":"10.1016\/j.ins.2025.122942"},{"key":"10.1016\/j.eswa.2026.133067_bib0017","doi-asserted-by":"crossref","DOI":"10.1016\/j.ins.2025.122942","article-title":"Large-scale text-to-SQL generation with adversarial defense","volume":"733","author":"Liao","year":"2026","journal-title":"Information Sciences"},{"key":"10.1016\/j.eswa.2026.133067_bib0018","series-title":"Findings of the association for computational linguistics: EMNLP 2020, online event, 16\u201320 november 2020","first-page":"4870","article-title":"Bridging textual and tabular data for cross-domain text-to-SQL semantic parsing","volume":"vol. EMNLP 2020","author":"Lin","year":"2020"},{"key":"10.1016\/j.eswa.2026.133067_bib0019","series-title":"Proceedings of the 60th annual meeting of the association for computational linguistics (volume 1: Long papers), ACL 2022, dublin, ireland, may 22\u201327, 2022","first-page":"2007","article-title":"Towards robustness of text-to-SQL models against natural and realistic adversarial table perturbation","author":"Pi","year":"2022"},{"key":"10.1016\/j.eswa.2026.133067_bib0020","article-title":"DIN-SQL: Decomposed in-context learning of text-to-sql with self-correction","volume":"abs\/2304.11015","author":"Pourreza","year":"2023","journal-title":"CoRR"},{"issue":"8","key":"10.1016\/j.eswa.2026.133067_bib0021","doi-asserted-by":"crossref","first-page":"193","DOI":"10.3390\/bdcc9080193","article-title":"Survey on the role of mechanistic interpretability in generative AI","volume":"9","author":"Ranaldi","year":"2025","journal-title":"Big Data and Cognitive Computing"},{"key":"10.1016\/j.eswa.2026.133067_sbref0022","series-title":"Proceedings of the 18th conference of the european chapter of the association for computational linguistics (volume 1: long papers)","first-page":"1812","article-title":"Aligning large and small language models via chain-of-thought reasoning","author":"Ranaldi","year":"2024"},{"key":"10.1016\/j.eswa.2026.133067_bib0023","series-title":"Proceedings of the 5th workshop on structured prediction for NLP, SPNLP@ACL-IJCNLP 2021, online, august 6, 2021","first-page":"12","article-title":"Smbop: Semi-autoregressive bottom-up semantic parsing","author":"Rubin","year":"2021"},{"key":"10.1016\/j.eswa.2026.133067_sbref0024","article-title":"PICARD: Parsing incrementally for constrained auto-regressive decoding from language models","volume":"abs\/2109.05093","author":"Scholak","year":"2021","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0025","article-title":"FINCH: Financial intelligence using natural language for contextualized SQL handling","volume":"abs\/2510.01887","author":"Singh","year":"2025","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0026","article-title":"Enhancing text-to-SQL translation for financial system design","volume":"abs\/2312.14725","author":"Song","year":"2023","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0027","article-title":"CHESS: Contextual harnessing for efficient SQL synthesis","volume":"abs\/2405.16755","author":"Talaei","year":"2024","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0028","article-title":"MAC-SQL: A multi-agent collaborative framework for text-to-sql","volume":"abs\/2312.11242","author":"Wang","year":"2023","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0029","series-title":"Proceedings of the 58th annual meeting of the association for computational linguistics, ACL 2020, online, july 5\u201310, 2020","first-page":"7567","article-title":"RAT-SQL: Relation-aware schema encoding and linking for text-to-sql parsers","author":"Wang","year":"2020"},{"key":"10.1016\/j.eswa.2026.133067_bib0030","series-title":"WWW \u201920: The web conference 2020, taipei, taiwan, april 20\u201324, 2020","first-page":"350","article-title":"Text-to-SQL generation for question answering on electronic medical records","author":"Wang","year":"2020"},{"key":"10.1016\/j.eswa.2026.133067_bib0031","article-title":"LinkAlign: Scalable schema linking for real-world large-scale multi-database text-to-SQL","volume":"abs\/2503.18596","author":"Wang","year":"2025","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0032","article-title":"Squrve: A unified and modular framework for complex real-world text-to-SQL tasks","volume":"abs\/2510.24102","author":"Wang","year":"2025","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_sbref0033","article-title":"UnifiedSKG: Unifying and multi-tasking structured knowledge grounding with text-to-text language models","volume":"abs\/2201.05966","author":"Xie","year":"2022","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0034","article-title":"MAG-SQL: Multi-agent generative approach with soft schema linking and iterative sub-sql refinement for text-to-sql","volume":"abs\/2408.07930","author":"Xie","year":"2024","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_sbref0035","article-title":"Type- and content-driven synthesis of SQL queries from natural language","volume":"abs\/1702.01168","author":"Yaghmazadeh","year":"2017","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0036","series-title":"EMNLP\/IJCNLP (1)","first-page":"1962","article-title":"CoSQL: A conversational text-to-SQL challenge towards cross-domain natural language interfaces to databases","author":"Yu","year":"2019"},{"key":"10.1016\/j.eswa.2026.133067_bib0037","series-title":"Proceedings of the 2018 conference on empirical methods in natural language processing, brussels, belgium, october 31, - november 4, 2018","first-page":"3911","article-title":"Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-SQL task","author":"Yu","year":"2018"},{"key":"10.1016\/j.eswa.2026.133067_sbref0038","series-title":"Proceedings of the thirteenth national conference on artificial intelligence and eighth innovative applications of artificial intelligence conference, AAAI 96, IAAI 96, portland, oregon, usa, august 4\u20138, 1996, volume 2","first-page":"1050","article-title":"Learning to parse database queries using inductive logic programming","author":"Zelle","year":"1996"},{"key":"10.1016\/j.eswa.2026.133067_bib0039","article-title":"FinSQL: Model-agnostic LLMs-based text-to-SQL framework for financial analysis","volume":"abs\/2401.10506","author":"Zhang","year":"2024","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_bib0040","article-title":"Sciencebenchmark: A complex real-world benchmark for evaluating natural language to SQL systems","volume":"abs\/2306.04743","author":"Zhang","year":"2023","journal-title":"CoRR"},{"key":"10.1016\/j.eswa.2026.133067_sbref0041","article-title":"Seq2SQL: Generating structured queries from natural language using reinforcement learning","volume":"abs\/1709.00103","author":"Zhong","year":"2017","journal-title":"CoRR"}],"container-title":["Expert Systems with Applications"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0957417426019780?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0957417426019780?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2026,7,4]],"date-time":"2026-07-04T04:33:07Z","timestamp":1783139587000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/S0957417426019780"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2026,12]]},"references-count":41,"alternative-id":["S0957417426019780"],"URL":"https:\/\/doi.org\/10.1016\/j.eswa.2026.133067","relation":{},"ISSN":["0957-4174"],"issn-type":[{"value":"0957-4174","type":"print"}],"subject":[],"published":{"date-parts":[[2026,12]]},"assertion":[{"value":"Elsevier","name":"publisher","label":"This article is maintained by"},{"value":"Enhanced financial text-to-SQL generation via fine-grained SQL refinement","name":"articletitle","label":"Article Title"},{"value":"Expert Systems with Applications","name":"journaltitle","label":"Journal Title"},{"value":"https:\/\/doi.org\/10.1016\/j.eswa.2026.133067","name":"articlelink","label":"CrossRef DOI link to publisher maintained version"},{"value":"article","name":"content_type","label":"Content Type"},{"value":"\u00a9 2026 Elsevier Ltd. All rights are reserved, including those for text and data mining, AI training, and similar technologies.","name":"copyright","label":"Copyright"}],"article-number":"133067"}}