Is there a way to achieve, via Scenario Editor, the Trade Workshop functionality seen in BR maps?

You can also use the actual new trade workshop object which automatically comes with resource generation, although you might need to edit the gamedata to unhide it from the scenario editor.