Is there a node for executing any sql statements?
in my case when re-running my analysis I want to first truncate the tables that will contain the result. Preferably that is also done in the workflow itself.
The Database Delete node is not a solution.
Is this possible at all?
The Database Reader, Database Connector plus Database Query node allow entering SQL scripts. The last line should be a SELECT statement which is parsed and returned as KNIME data table. All lines prior the SELECT are executed as well, but the results are not parsed, for example to set variables or create temp tables or views inside the database.