feat(adapter/kv): support async iterating on scan results (#5208)

feat(adapter/kv): support async iterating on scan results (#5208) #607