Saw this post a while ago: https://medium.com/@dadc/aws-appsync-the-unexpected-a430ff71... - did you hit any limitations with AppSync?
https://blog.hasura.io/graphql-and-geo-location-on-postgres-...
PS: I work here. Apologies for plug.
It's a great complement to serverless and static front-ends.