MQTT sink: publish to different topics depending on a column

[xxchan]

concerning MQTT sink/source:
I think it's useful for sources to be able to subscribe to wildcarded topic like devices/sensors/# and that's a great feature.
On the other hand, it would be very useful to be able to publish to different topics depending on a column of the sinked view, Contrary to kafka, it's common practice in MQTT to have a lot of sub topics like devices/actuators/{id} . creating a sink per actuators wouldn't be efficient if even possible. Having one topic for all actuators would defeat the purpose of MQTT.

Slack Message

[xxchan]

#15673