(Too lazy to try this out) It is possible that the prepare failed because it is trying to prepare a single SQL statement, but that a $dbh->do("sql 1; sql2") might work.

This would probably work on the example given (create FOO; create BAR;), but not on the problem to be solved (lack of sub-select), since do isn't going to help on selects.