Do join/Union/CTE statement over multiple table for advanced analytics

Please provide the feature to perform join/Union/CTE statement over multiple table within dashboard feature. I know we can do it on the app by creating individual queries/aggregations but it will be nice to do it in dashboard app for the quick win.