Is it possible to use and get results from SQL tables that contain financial data? Table structure is very complicated. I have created a view that contains date, account name, debit and credit columns.

I just want to get the answers for questions like "what is the total sales for 2024 ?", or "what is the total receivables" , etc.

I have tried creating a vector index for the same and tried querying from chat bot using the vector index but no luck...

Can anyone help me achieve this?