[Maps] Add Elasticsearch SQL Data Source and Support for WKT

[alexfrancoeur]

As Igor progresses with geosql (elastic/elasticsearch#42031), we should consider how we can introduce SQL as a data source for Elastic Maps. We could offer an experience similar to Canvas, but I feel like we'd need to validate the WKT response.

[elasticmachine]

Pinging @elastic/kibana-gis

[thomasneirynck]

blocked by #32074

[alexfrancoeur]

Update, the original SQL PR has been merged into master. 7.x is here elastic/elasticsearch#42135 and in progress

[imotov]

7.x is now merged. I played with canvas on Friday by loading geonames dataset and requests like

SELECT ST_X(location) x, ST_Y(location) y, population FROM "cities" WHERE country_code = 'US' AND admin1_code = 'NY'

were returning me:

That obviously works only for points and it would be really cool to have support for other shapes as well.

Please, let me know if I can do anything to make it easier for you. I think I can pretty easily add ST_AsGeoJSON(geom) function which will return shapes as a GeoJSON string instead of WKT string for example.

[elasticmachine]

Pinging @elastic/kibana-presentation (Team:Presentation)

[ThomThomson]

closing this in favour of maps supporting ESQL.