add integration tests for async queries