If you need purely the answer looks like a good solution could be a fine-tuned encoder + decoder. You provide table description + query and as an output you get a generated query which you execute and present the response. If that is not an option indeed it is worth looking into other LLMs, as mentioned by @VietCat Gemma 3. Here you should experiment and see what works better
2 Likes