Creating KNIME Nodes from External SQL Scripts Using Python

Hello KNIME Community,

I have a question regarding the possibility of creating KNIME workflow nodes outside of KNIME Analytics Platform. My use case is as follows:

• I have multiple SQL scripts that I would like to use as individual steps in a KNIME workflow.

• I work primarily in Python and would like to automate the transformation of these SQL scripts into corresponding KNIME nodes.

• Ideally, I would like to generate these nodes programmatically and integrate them into KNIME without manually configuring each one inside the Analytics Platform.

Is there a way to achieve this?

Would KNIME’s API or extensions allow me to create, import, and execute such nodes dynamically?

Any guidance, references, or examples on how to approach this would be greatly appreciated!

Thanks in advance for your help.

Zoe