You should have a look at PostgREST, still in development but look like a promising missing link for you use case.