Basically Google kidnapped some valuable data in this Ads Data Hub and established a query interface that only works in ADH. Think of ADH as a database the doesn’t allow certain data out. So ppl have to design their queries in ADH and dumping aggregated results into BigQuery, which sounds stupid.
Now unfortunately the ADH API v1 doesn’t seem to allow plain query strings. But we can always push Google ppl to build it in v2. I’m hoping once we have the capability of sending plain query strings via an ADH API, we can build a data source plugin in Redash (similar to AWS Athena I guess).