Since playing with DBIx::Class and related also within (as mentioned above) Catalyst and on it's own , I am seriously considering it for new projects and _almost_ tempted to port existing work over to DBIx::Class from Class::DBI.
AFAIK DBIx::Class::Schema::Loader does not automagicly figure out fk relationships (does not work for me) but I generally turn relationships off in the Loader and DWIM explicitly in the loaded classes. Check out DBIx::Class::Manual::DocMap , read it all.
I can't believe it's not psellchecked