Thank you for the question.

PostgREST is an excellent option for those who want a REST API with good performance and minimal effort.

Pro: Minimum effort for CRUD endpoints and freedom to build endpoint with custom-logic through stored procedures. The use of stored procedures can be very advantageous in terms of performance in cases where large volumes of data are crossed.

Cons: Only supports PostgreSQL DBMS. Allows writing custom logic only in PL/pgSQL or JS.

A deeper analysis is needed to compare PostgREST with solutions based on other paradigms, such as GraphQL.