At Patterns, I built an AI agent that translates user questions into SQL, executes them against a data warehouse, and uses the results to create visualizations in VegaLite.
There's a ton happening under the hood in that process, and designing and implementing the system that can reliably perform this task on a generic set of questions that can change depending on what the data is proved to be a gargantuan task.
If you need help implementing AI in your app, reach out to me and we can make it happen.