Someone around with experience running this in production? Did you find any major pain points when integrating in a client app (let's say React, Svelte or alike)?
The trouble I felt in the past with the concept of DB as source of truth was to manage business logic (eq. in stored procedures) in a way, that works for a distributed team efficently.
IMO the the source of truth for Views and Stored Procedures should be a git repository, where developers change them in a .sql file, and the CI tests and updates them in the databases.
Overall though, the user experience was generally very good and we still use it for some smaller standalone components on otherwise static websites (e.g. a mailing list signup form) where you don't need complex joins.
Perhaps you mean no left-join support? There has been support for inner-join support in PostgREST for a few years :)
(example: https://supabase.com/docs/reference/javascript/select#query-...)
Usually you should be fine with a few views, in most schemas, there are just a limited amount of tables you can join in a meaningful way.