The "feature" you're talking about is called cascading delete, and according to this message, the author doesn't see any reason to turn off cascading delete. As far as other modules, I think Class::DBI is the easiest to use, but there is a list and comparison of others at http://poop.sourceforge.net/.