Hi, we currently have an application where we have to combine two different PostgreSQL databases holding parts of our data model. However, the total data model spans both databases, meaning that we have references between database 1 and database 2. For example, we have a one-to-many relationship in the data model for our group and unit entity, a group can hold multiple units. The group entity elements are stored in database 1 whereas the unit entity elements are stored in database 2. Would it be possible to use Prisma as an abstraction layer on top of these two databases?

this might help — https://www.cybertec-postgresql.com/en/joining-data-from-multiple-postgres-databases/