There are cases where doing a join in code can make sense. E.g. when you already have a whole table cached in application memory, and the primary purpose of the

There are cases where doing a join in code can make sense. E.g. when you already have a whole table cached in application memory, and the primary purpose of the join is more ORM-like and not any kind of aggregation or grouping on a joined column.