The DBI modules isolate you to a large extent from the differences between databases. DBI::Class, as well as some other modules, furthers that isolation.

HTML::Template or Template::Toolkit or similar modules separate the presentation structure from the logic.