My favorite wrapper is Data::ObjectDriver. I can't say I'm well versed in all the data abstraction methods and modules out there, but I've found it to be the easiest to use.

My only complaint is that there's no Oracle driver available for it. The guys that wrote Data::ObjectDriver have written a Oracle driver (it's used in Movable Type), but haven't released it to CPAN.