Wouldn't say this is completely black and white, but if you're using Event Sourcing w/ a tool like Marten that does have reasonably robust support for Projections, I think that you probably shouldn't ever be needing to use database joins or very much DTO mapping at all in your "query side"