I am currently using a SQL Client called Dbeaver to query data from Postgresql and MySQL database individually. But recently there is a use case, where there is a need to combine data from this two database and then write a query.
Dbeaver doesn't have this capability. So I want to know if this is a limitation in all SQL Client or just DBeaver. If the issue is with DBeaver, then which SQL Client will allow me to combine data from two different database and then write a query?