[Dbix-class] Newbie question

[ivan]

I wish to realise SQL in DBIx syntax:

select * from table1 left join ( select * from table2 where date =
'mydate' ) as F ON ( table1.id = F.table1_id );


Is it possible ?