I would like to dynamically draw the shortest line to the next object (Geometry Generator?).
Example: I have a network-layer (streets) and a point-layer. I know the distance from every point to the closes street (static, by using v.distance or one of the plugins NNjoin or refFunctions) but I would like to have a dynamically drawn line to the next street with the distance as label. It's important to have it dynamic, so if I move a point, the line and distance should update. Since I use GeoPackage a SQL-Solution would also be nice.
In the screenshot below you can see my static solution: