[Dbix-class] Left join on multiple columns

[Ronald J Kimball]

John Goulah wrote:
> This leads to the question of whether you can write straight SQL in 
> times like these.  I suppose it breaks the design, but sometimes its 
> just easier to write SQL... Is it possible?

Yes, you can.  That's actually what I have in my code right now.  Like so:

my $dbh = $schema->storage->dbh;

my $sth = $dbh->prepare(<<"EndOfSQL");
   ...
EndOfSQL

$sth->execute();

while (my $row = $sth->fetchrow_hashref()) {
   ...
}

Ronald