If one wishes to "cut out the middle tier" they might be better served by a investigating a project like PostgREST [0]

[0] https://postgrest.org/en/stable/