It is really hard - DBIx::Class (Perl) is an example of one of the better ones, in my opinion.