[rudasn]

Can it handle loading data from let's say 100 pg databases (of the same schema but different tenants) and query them as if all the data was in a single database?

I think that's my main issue with tools like this.