In my opinion, event without a `@Fetch` annotation JOIN should not be used is the query has offset or limit set or if it fetches multiple collections, since in the former case it will load potentially millions of rows and apply the pagination in memory, in the latter it will throw an exception.