SQL connector INSERT multiple rows

Insert multiple rows using db connector

the answer to this isn't perfect
How to insert multiple rows in MySql DB using My SQL Connector.

In the scenario where a variable is a List BDM object, the plain sql statement wouldn't work.
Would the correct strategy be to use a Groovy script then?