Best way to text-to-sql

Hi all,
I have a requirement to use text-to-sql model.
Needing some suggestions here to go for an LLM, LLM + Fine tune or use a model from Hugging face. All pointers and suggestions are welcome on which model will perform best on converting text to complex sql queries.

The best practice at HF is often to find someone else’s good work and take their strengths in their entirety.
It’s likely to be there.