Not advocating for or against, but having worked on systems like this, the joins here would happen in the Fetchers. That is, User is the domain object, which c

Not advocating for or against, but having worked on systems like this, the joins here would happen in the Fetchers. That is, User is the domain object, which could be built from one or more database tables inside the Fetcher.