Agg pushdown is a thing in FDW, I hadn't really thought about the extent to which pulling rows into PgSQL and then summarizing them is a waste of time. I imagine actually implementing agg pushdown in the parquet_fdw might be too much to ask of it (basically writing part of an execution engine in the FDW) but boy it is an interesting thought, since so much data lake querying is aggregation.