Postgis has an ST_AsKML function which would allow direct import into Google Maps. This could be implemented as another extension type. https://postgis.net/docs/ST_AsKML.html