[D] LLM with analytical capabilities

My boss asked me to create an application which can be connected to Redshift or Postgres databases and can retrieve numerical data and can answer financial and analysis questions for the company. He doesn't understand that RAG technique is not suited for numerical analysis stuff. Any idea how I can achieve this.

He mentioned to use amazon Q for this task, which I find is awful in giving answers to numeric datasets

analysis and analysis application boss capabilities data databases financial llm machinelearning numerical postgres questions rag redshift the company