Postgres has something similar called pgREST too. I think I would only adopt these kinds of interfaces if the consumer insists on accessing the data through a R

Postgres has something similar called pgREST too. I think I would only adopt these kinds of interfaces if the consumer insists on accessing the data through a REST interface. If you are building something from scratch, or your consumers don't have a hard requirement for going through REST, I would go directly to the database view.