[Dbix-class] DBIx::Class query with UNION and RIGHT JOIN

[Jess Robinson]

On Mon, 28 Jan 2008, Will Hawes wrote:

> On 27/01/2008, edwrb . <datecrepe at hotmail.com> wrote:
>>
>>  Hey gang,
>>
>> I have a UNION query with a right join that I need to implement in
>> DBIx::Class.
>
> AFAIK, DBIC can't do that (yet ;):
>
> http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Arbitrary_SQL_through_a_custom_ResultSource

Well not natively, but nothing (currently) restricts you from putting 
"whatever you like" in an order_by clause, so..

Jess