For simple stuff, I really like Class::Tables. It has some rough edges and presumes a convention for foreign keys, e.g. if you have a table users with an id column and a table groups with a foreign key which references the id column in users, that column in groups must be named users_id. It is quite small, but though old and discontinued, still a gem on CPAN imho. It is worth studying and nicely hackable.