> I generally find that an ORM makes easy things easy and difficult things indescribably hard or impossible.

I agree, but raw sql makes the easy thing hard (or at least cumbersome), so the nice middle ground is to use hibernate for the easy things and sql for the hard things.