The problem with Class:DBI is that it only supports single field keys and cannot work with multiple field keys. You would have to further normalize your tables so they all have single field keys to get it to work. I don't think it is worth the bother and it is better to add in your class some custom-written sql (__PACKAGE__->set_sql(your sql here)) which you can access by using the search_your_sql statement.