in reply to joining tables with SQL::Abstract

SQL::Abstract is used in DBIx::Class. See what they do.
My criteria for good software:
  1. Does it work?
  2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?

In Section Seekers of Perl Wisdom