No, DBI/DBD just passes the sql statement to the database. But from the syntax of INSERT, it looks like you are not allowed to have a specific column list to insert into if you have a subquery (maybe it depends on the Oracle or Oracle client library version?).

But, I agree with the poster elsewhere in this thread that a sequence would be a much better way to get an incrementing value.