If I were writing this query by hand, I would use a SQL JOIN, which I would expect to be much more performant. Would an ORM reasonably be able to recognize that pattern and implement this in a single query, or is using an ORM necessarily a performance trade-off in exchange for convenience?