PostgREST is a phenomenal project, and you get A LOT for it's design. How many thousands of applications are simply wrappers around CRUD databases? PostgREST gives a great REST API implementation for exactly this use case. PostgREST probably has a more robust API interface than 70% of basic CRUD apps, with RLS built in.

Am I using PostgREST for a project with lots of complex backend logic, long running tasks, etc? Absolutely not. But that's not what it was built for.