Data catalog features

Selecting only particular output fields should theoretically be possible but only as long as these fields are defined in the catalog item metadata. It won't be possible to know ahead of time the output field names if they are calculated dynamically.

"Aggregate by lookup" can be done by unpivoting, filtering, aggregating with grouping, and then pivoting back. Something like this: Dynamic Aggregation - #4 by dgudkov