There is already a prism method to do this (prism.debugging.GetJaql) but we would need a backend equivalent.
We would need to fetch the JAQL associated with a table/pivot widget by providing
- dashboard id,
- widget id
- cube name (?)
This is to enable us to invoke the /api/datasources/[cube name]/jaql/csv method.