Is there a particular reason to make your life harder than it has to be?

Anyway, DBI generally allows only one statement per do or prepare.

So you have to break it up into statements, for example with a SQL Parser