Parsing Data in a template #784
Description
Is your feature request related to a problem? Please describe.
So, I have created a template, added my custom datasource, which means, I have datasources I was using locally, it includes tables and columns, this works as when I open a template in the designer, I get the datasources, and the user can design how they want their template to look, now the issue comes when we are trying to export, because now there is no endpoint or way that I can say, okay, you choose booktransactions table and id, date, reason columns, I query the database and here is the data in the report and be able to export it, usually when you connect with the a database, this works as you have access to the database, but what if there is no access to the db and I want to make my own custom queries
Describe the solution you'd like
We can have an endpoint, where I parse data for the variables a user has added in a template, maybe on export, so that I can give the actual data I want on an export
Describe alternatives you've considered
I have considered using a database datasource, with a connection, that would work but now I can't have my custom datasources, and imagine telling a user to search for a table or column in a large database that has many tables and columns?
Additional context
Add any other context or screenshots about the feature request here.
