|P is for Practical|
"... they may require some other software or installing a different version of perl instead of using the preinstalled version."
Firstly, don't modify the Mac OS X System Perl in any way. Apple installs its own version of Perl for its own use. Any changes you make can interfere with how this works; any updates to the Mac can interfere with whatever you've done.
I started using a Mac a couple of years ago and asked "Are there any major Perl issues with Mac OS X Lion?". That may be a little dated now and you could be working on a different version; however, I believe the basic information is still sound. I chose the perlbrew option: it's worked without problems with many versions of Perl. See App::perlbrew for installation and perlbrew for command details.
"The big question is whether the same thing can be done on OS X."
I wrote this short test script (pm_test_pp_tk.pl) and tested it successfully:
I then used pp:
I successfully tested pm_test_pp_tk.exe.
You may already be aware that there's a substantial difference in the sizes of those files:
I leave testing with DBI, and any other modules you might need, as an exercise for your good self.