Generating different APIs from the same schema

Hey :)

I have a use case that may be relevant for more people (maybe a similar form of the problem) so after talking to the support team, they advised me to open up a discussion here :)

TL;DR

Generate multiple APIs on top of the same schema (and DB), each API exposing parts of the schema.

Detailed

We develop 2 applications. One of them is B2C, which will be open-sourced & free to use. The other is B2B, closed & has costs for usage. The apps share & interact on some of the data, so to enforce consistent and accurate relationships on both sides, we wish to use a single PostgreSQL DB. Can supabase help with generating 2 sets of APIs from the same DB (so private schema is not exposed in the open-sourced API)?

See below a diagram for clarification:

<img width="387" alt="Screen Shot 2022-07-03 at 22 10 16" src="

Thanks!