 <p>Each any() usage is converted into it's own subquery. If you need to combine multiple conditions you will need to write the subquery yourself.</p> <p>any() isn't a join alternative, but a subquery exists shortcut. Maybe that helps.</p>