How good is Hasura and is it worth the hype?

I was researching about adding memcached or redis cache capability as well as graphql to my semi social app I'm working on after hitting network issues due to multiple api calls to mongodb database.

I found in my early stage mistake that relational database will be best suited for the app than a nosql database. So I started thinking of how to revamp my app with postgres + graphql + apollo client, this is when I came across Hasura. I have been researching about it for the past week, they sell it like I can have Hasura => postgres + graphql + apollo client and I would not need a server side code, but for some of the examples I have seen, it seems I might still need to code the api calls with the graphql queries embedded which does not seem like a big deal. My worries is that Hasura integrates some specific payed third party services like Hiroku for hosting (I think they let you choose providers as well) and Auth0 for authentication. I dont know if I can use other authenticators that my be open source while still using the postgres database. In all I am curious if the Hasura => postgres + graphql + apollo client stack is worth it, if anyone have experience with this stack and if there are foreseeable issues I might encounter.