Other useful posts:
A Growing Dislike for SQL-OOP Mappers
-- Catalyst superstar chris discusses some of the disadvantages of db->object mappers. note: I am very enthusiastic about the Catalyst project myself, and the fact that its developers are realistic about its shortcomings makes me if anything even more willing to drink the kool-aid :)