in reply to prepare, execute and return the product - Perl DBI

Maybe you want something like DBIx::RunSQL?

But seriously, I fail to see what's so difficult with generating a list of statements and then looping over a $dbh->do( $_ ) statement for them. I think somebody recommended that to you already in Combining variables to create a single virtual variable.