Decouple the query mode from the underlying call mode for buffer
workers.
Prior to this change, setting the query mode of a resource
such as a bridge to sync would force the buffer to call the
underlying connector in a synchronous way, even if it supports async
calls.