I’m a table-as-api fan. In my opinion it makes it clear to all possible consumers what the things are. Ofc depending on case one can layer different kind of api layers on top when needed. I think the best way to achieve this is to separate the public api (semantic entities) and internal apis (stg, int, what-not) to different schemas. Then it’s easy to just grant access to people to the public api schema
I’m a table-as-api fan. In my opinion it makes it clear to all possible consumers what the things are. Ofc depending on case one can layer different kind of api layers on top when needed. I think the best way to achieve this is to separate the public api (semantic entities) and internal apis (stg, int, what-not) to different schemas. Then it’s easy to just grant access to people to the public api schema