Support of database-native spatial data in maps

[SeppBerkner]

Description

I am working as an analytics engineer in the energy sector and we are using Postgres database as our data warehouse because we need rich spatial data manipulation support using the PostGIS extention. It would be great when Evidence could support the PostGIS "geometry" data type in the visualization in its maps (LineStrings, Polygons, Points and Multi-features). This way the geometry can be loaded directly from the database with the SQL statement without the extra steps of generating a geojson and storing it somewhere.

What problem would this solve?

No need to generate geojson and more support for all geometry types (like LineStrings)

How should it work?

Example for a point layer

select
    id,
    3 AS value,
    ST_SetSRID(ST_MakePoint(-71.1043443253471, 42.3150676015829), 4326) AS geom
from
    my_spatial_table

{% map %}
{% point_layer
geography="geom"
data="spatial"
area_id="id"
value="value"
/%}
{% /map %}