Just a recording of a failed attempt to figure out what is wrong. The problem seems to be with an internal SQL::Abstract method that is used by Class::DBI::Sweet (_recurse_where), which is reworked in the 2.0 release, so a two-level join isn't handled.
It is not clear to me whether SQL:A is to blame or C:DBI:S. Should be the later, since SQL:A can't actually know which class/table corresponds to the joined alias or how to construct the join expression. Anyway, If I had to decide today what happens with the package, I'd consider two options: removal of the package, and removal of the two-level join from documentation/tests. -- Damyan