generate-vector-tile.sql

WITH tilebounds (geom) AS (SELECT ST_TileEnvelope($1, $2, $3)),
query AS (
  SELECT ST_Makeline(geom ORDER BY field_order) as geom FROM path_test 
)
SELECT ST_AsMVT(q, 'default', 4096, 'mvtgeom')
FROM (
  SELECT
    *,
    ST_AsMVTGeom(
      ST_Transform(query.geom, 3857),
      tileBounds.geom,
      4096,
      256,
      true
    ) mvtgeom
  FROM query, tilebounds
  WHERE ST_Transform(query.geom, 3857) && tilebounds.geom
) q