DBIx-Class sucks sometimes

mmmm, I just convert one complex SQL sentence into DBIx-Class like, but it doesn't work at all. I ask the maillist around, the answer is no way.

see http://lists.rawmode.org/pipermail/dbix-class/2006-July/001894.html for more details.

I think I should use ->storage->dbh instead. mmm, I should do the pager myself.(I like the built-in pager in DBIx-Class a lot.)