Just want to give a shout out to Hasura (https://hasura.io/) here which removed a lot of these problems for me.