Text to SQL and Reverse

I need to make custom chatbot on my web app.CLient can ask for some datas from my sqlserver databse for example can you give me avergae value of this price for march 2023 or something similiar.How to design that.Should I use NLP model (text to sql from HF) and then fine tunned it ,how can I generate datasets for all use cases on fast way can someone help me with practical steps.