Hot off the press collaborative coding platform: A pull request introducing ST_AsMVT and ST_AsMVTGeom has been merged into the DuckDB spatial extension. Similar to PostGIS, these two new functions will allow DuckDB to serve vector tiles in the Mapbox Vector Tile (MVT) format.
Max Gabrielsson has published a 160-line gist1 demonstrating how to set up a Flask2 app that serves vector tiles from DuckDB in a webmap.
The idea first emerged in January of last year. The feature is scheduled to ship in DuckDB version 1.4 next week!