Is it possible to generate map features through the use of PostSQL

[OstiumAxioma]

trafficstars

Feature request

Is your feature request related to a problem? Please describe.

I am currently using a geology information database based on PostgreSQL. It uses an extension feature of PostgreSQL which is PostGIS. All the operation and requests query sentences are provided by PostGIS, but the Database-Build need to render the information PostGIS generated on a map, like in OpenLayers

Describe the solution you'd like

1. User sends request through natural language to let PostGIS know what to generate. Like: showing all the Cafe in Manhattan.
2. Backend LLM connected receive the request and turns into SQL languages
3. PostGIS process the SQL languages and generate JSON that contains the feature
4. Frontend generate the features on a basemap, just like generating a diagram

Describe alternatives you've considered

Haven't got an idea about how to achieve this alternatively.

Additional context

Add any other context or screenshots about the feature request here.