When ever the DB Table Selector Node parses the query to the database , it appends select * from ahead of the query that we are using . For eg : If we use Select * from table_name , KNIME will read it as select * from (Select * from Table_name)
Is there a way to remove the additional " Select * from " from ahead of the query .
I need to basically execute "Explain select * from table_name " to get the cost of the query .