Display a map to draw geometries as WKT for text paramters in spatial db

[mathieubossaert]

An old idea discussed here, to geo-enable dashboardsd , by adding the capability to draw a feature on a map :
https://discuss.redash.io/t/add-a-geom-parameter-type-to-query-spatial-databases/3340

I use redash in a Nature conservation NGO. Some of our dashboards are reporting species and habitats lists that have been observed on the queried site but sometimes the zone of interest we want to query does not pre-exist in the database (PostgreSQL / PostGIS).
It would be great to be able to propose a map to draw a polygon as an input of a WKT or geojson geometry.
So we could use it in the WHERE clause of dashboard’s queries as :

WHERE st_interesects(species.geom , ST_GeomFromText({{site_geom_param}}))

[sbathgate]

Had made a post over in #6111, just want to indicate this would be hugely beneficial use case for my needs too.

[konnectr]

maybe create issue ?