PostgREST is pretty cool but I can never figure out a use case for it. You want something that’s not too cold, doesn’t interact with other systems, and it’s worth it the additional security effort for configuring postgres.
I think people also widely misunderstand how it works, which doesn’t help if course. It’s not just a database you can access on the internet, there’s a while bunch of security you set up first, and it uses the native row based security features to separate users’ data.