Postgres Foreign Data Use Case

Hi! Here is a simple use case of how pg query federation could be used. Hoping I could get some feedback to why/why not people would do something like this. Keen to also hear from people that do this already. Thanks heaps!