## 3 Model Design and Implementation
### Pre-Processing
In addition, enhancing the cross-domain adaptability of the method, especially when facing different database systems and application scenarios, can improve the model's generalization ability through broader corpus and pre-trained models. At the same time, further combining reinforcement learning and automatic tuning mechanisms is expected to make the method more robust and flexible in practical applications. [PERSON], [PERSON] and [PERSON] wrote the main manuscript text. [PERSON] and [PERSON] provided the idea and prepared the data and figures. All authors reviewed the manuscript. All authors have read and agreed to the published version of the manuscript. The work of this paper is supported by the National Key Research and Development Program of China (2019 YFB1405000) and the National Natural Science Foundation of China under Grant (No. 61873309, 92046024, 92146002). The dataset is from [[https://bird-bench.github.io](https://bird-bench.github.io)]([https://bird-bench.github.io](https://bird-bench.github.io)) (accessed 15 July 2024). Author [PERSON] was employed by the company GianTech Technology Co., Ltd. The remaining authors declare that the research was conducted in the absence of any commercial or financial relationships that could be construed as a potential conflict of interest. ## References

* [PERSON] et al. (2024) [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; et al. A Survey of NL2 SQL with Large Language Models: Where are we, and where are we going? _arXiv_**2024**, arXiv:2408.05109. * [PERSON] et al. (2024) [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON] A Survey on Employing Large Language Models for Text-to-SQL Tasks. _arXiv_**2024**, arXiv:2407.15186. * [PERSON] et al. (2018) [PERSON]; [PERSON]; [PERSON]; [PERSON] What it takes to achieve 100% condition accuracy on WikSQL. In Proceedings of the 2018 Conference on Empirical Methods in Natural Language Processing, Brussels, Belgium, 31 October-4 November 2018; pp. 1702-1711. * [PERSON] et al. (2018) [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; et al. Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-sql task. _arXiv_**2018**, arXiv:1809.08887. * [PERSON] et al. (2024) [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON] Business intelligence in the era of big data: A review of analytical tools and competitive advantage. _Comput. Sci. IT Res. J._**2024**, 5, 415-431. [CrossRef]
* [PERSON] and [PERSON] (2023) [PERSON] [PERSON]; [PERSON] [PERSON] A survey on deep learning approaches for text-to-SQL. _VLDB J._**2023**, 32, 905-936. [CrossRef]
* [PERSON] and [PERSON] (2014) [PERSON]; [PERSON] [PERSON] NaLIR: An interactive natural language interface for querying relational databases. In Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data, New York, NY, USA, 22-27 June 2014; pp. 709-712. * [PERSON] et al. (2022) [PERSON]; [PERSON]; [PERSON] [PERSON]; [PERSON]; [PERSON] [PERSON]; [PERSON] [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; et al. Importance of synthesizing high-quality data for text-to-sql parsing. _arXiv_**2022**, arXiv:2212.08785. * [PERSON] (2017) [PERSON] Attention is all you need. Advances in Neural Information Processing Systems. In Proceedings of the 31 st Conference on Neural Information Processing Systems (NIPS 2017), Long Beach, CA, USA, 4-9 December 2017. * [PERSON] et al. (2024) [PERSON]; [PERSON] [PERSON]; [PERSON]; [PERSON]; [PERSON] [PERSON] Chess: Contextual harnessing for efficient sql synthesis. _arXiv_**2024**, arXiv:2405.16755. * [PERSON] et al. (2024) [PERSON]; [PERSON] [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON]; [PERSON] [PERSON] Codes: Towards building open-source language models for text-to-sql. _Proc. ACM Manag. Data_**2024**, 2, 1-28. [CrossRef]
* [PERSON] and [PERSON] (2024) [PERSON]; [PERSON] Din-sql: Decomposed in-context learning of text-to-sql with self-correction.