I am sorry - is this posting for real?

I know how to do it in plain SQL - that was not my question.

And had you played with DBIx::Class for even a minute you would know that "telling" DBIx::Class is sometimes not so straightforward.

I'm too lazy to read the docs on how to do it.

Sure, why not post something entirely useless instead...