Introduce an async querying mode for SQL, similar to [EQL's](https://www.elastic.co/guide/en/elasticsearch/reference/master/eql-search-api.html) (based on ES' async search).