Under the hood, DBIx::Class uses SQL::Abstract for SQL generation. Check those docs. Alternately, head over to irc.perl.org #dbix-class - they're extremely responsive and you can usually get mst, castaway, or one of the other devs/power users to answer within minutes.
My criteria for good software:
Does it work?
Can someone else come in, make a change, and be reasonably certain no bugs were introduced?