I half expected this to promote Postgrest or one of it's alternatives and was surprised it didn't do that by the end of the post.
I used it for this exact usecase, we had some data in postgress and front-end had limited api, and readonly postgrest was simpler than adding the api I needed to the frontend.