In a "SQL Query" recipe, you should enter a SELECT query, not an INSERT. DSS will take care on its own to actually transform the SELECT to an INSERT if the output is SQL, or to stream the results if it is not.
You might want to check: http://doc.dataiku.com/dss/latest//code_recipes/sql.html