[Dbix-class] SELECT from multiple tables

[Emmanuel Quevillon]

Hi,

I am a big fan of DBIx::Class, I think that is a great tool.
However, I did not find an easy way to query database using 
multiple table in the FROM clause with DBIx::Class e.g:

SELECT p.id, p.name, q.id, q.level FROM public p, group g 
WHERE p.id=g.id AND p.name LIKE '%class%';

I know you'll answer, "Why don't you use join?". Well when I 
use join, my queries are very slow sometimes, and I realized 
that querying this way is much faster (in my case at least).

So I'd like to know if it is possible to create such query 
with DBIx::Class?

Thanks in advance.

Regards

Emmanuel
-- 
-------------------------
Emmanuel Quevillon
Biological Software and Databases Group
Institut Pasteur
+33 1 44 38 95 98
tuco at_ pasteur dot fr
-------------------------