1. 4

    There is also PostgREST[0] which helps do a lot of this for you.

    0: https://github.com/PostgREST/postgrest

    1. 3

      There is also PostGraphile.

      They have a very good tutorial on PostgreSQL Schema Design in regards to using DB as an API.