[Dbix-class] Select from subselect

[Peter Rabbitson]

Allan Cochrane wrote:
> 
> 
> On Fri, Dec 16, 2011 at 5:40 AM, Peter Rabbitson <rabbit+dbic at rabbit.us 
> <mailto:rabbit%2Bdbic at rabbit.us>> wrote:
> 
>     This is correct, DBIC currently has no facility to express arbitrary
>     joins
>     between arbitrary chunks of SQL. What are you actually trying to achieve
>     here? Is there a reason you are not running said query against the
>     handle
>     directly with $schema->dbh_do ?
> 
> 
> I have been using DBIx::Simple and SQL::Abstract with multiple tables 
> and it was working well. Recently the schema changed and we've moved to 
> a single table so I though I'd use DBIx::Class to do the job, I hoped it 
> might remove the need for some of the fixed SQL I currently have. It 
> would appear that I need to go back to what I had before and adapt that 
> code to the new model. Thanks all for your help.
> 

Aye. Eventually we will have an API to do this seamlessly, but for the
time being it's much simpler and cleaner to do it by hand.