So is this an FDW that provides a similar function to Amazon Athena?

Does every query fetch everything again or does it somehow cache the downloaded data files?

Running something like this on EC2 is interesting as you wouldn’t pay the intermediate transfer costs. Only the final results would egress.