When you need to access multiple resources (eg different DynamoDB tables) from a single custom gql operation using AWS Amplify, why would you use pipeline resolvers over lambda resolvers, and vice versa? From reading around, there seems to be very little information regarding the advantages/disadvantages of each approach, as well as use cases where one might be better than the other.
I've read that debugging pipeline resolvers is a nightmare because you can't print/console.log, so if true, that is one huge downside of pipeline resolvers and a reason to use lambdas instead...
Some thoughts (though not exhaustive):
That said, you don't necessarily need pipeline resolvers to access multiple data sources; you can set up multiple data sources with multiple resolvers that can be executed in the same request.
You might also want to look at https://github.com/serverless/serverless-graphql/issues/248 which contains an interesting discussion on the advantages and disadvantages of using multiple DynamoDB tables behind an AppSync API.