The parameters in the SQL should be in correct order, and does not support using named placeholders. So you have to use the # for each placeholder.
The body will be iterated, so it can contain a List which has the parameters.
The camel-sql component uses Spring JDBC under the hood, so that framework may log the SQL statement.
We may be able to improve camel-sql so it also logs the statement. But its using a PreparedStatement so the placeholders is bound.