[Dbix-class] help building query w/ ->search() or using arbitrary select?

[George Hartzell]

For future reference, *is* there a way to specify arbitrary sql and
have it mapped into objects?

Thanks,

g.