Greetings,

If I understand PrefetchPaths correctly, you can only have prefetch paths for relations defined on the entity. What if I want to prefetch another entity (table or even view) that don't explicitly have any PK-FK relation with the current entity (in SQL I just build whatever join I want in the FROM clause as long as I am specifying the ON clause correctly)

Is it possible to do the same in LLBL ?

Prefetch paths are used to fill related collections and references to other entities which are normally initially not loaded. So if the entity Y doesn't have a relation with another entity X, it doesn't have any collections internally where instances of X can be stored, so having a prefetch path for instances of X when instances of Y are fetched is then not necessary.