[Catalyst] subqueries

[Octavian Rasnita]

Hi,

Is it possible to create sub-queries using DBIx?

I want to do something like:

select me.body, me.date, me.time, me.username from(select me.id, me.body, 
me.date, me.time, user.username from forum me join user user 
on(me.id_user=user.id) where me.id_room=3 order by date desc, time desc 
limit 10) as me order by date asc, time asc\G

Thanks.

Octavian