Hacking around the ORM should be a question of:

    query.SQL("my complex query here")

If it's not, your ORM is broken and you should write a new one (they're really not that complex).