I think at least DBD::Sybase can return multiple resultsets, but you need to explicitly enable that feature.

For other DBDs, you will also have to review the respective documentation I guess.