This is a bug fix for an issue raised at #3626 (comment)

The fix/change is for when filterMany predicates get included into the main query, for those predicates to be included in the JOIN clause rather than the WHERE clause. This simplifies the how filterMany works when it is included in the main query, when it is NOT included in the main query but instead part of a separate query (effectively a fetchQuery) then the predicates are included in there WHERE clause of the secondary query.

Reference (bit of a sordid history here):

Original inline support - #2222 (version 12.9.0)
Related Bug 1 - #3453 (version 14.5.2)
Related Bug 2 - #3625 (version 16.0.0)
Issue prompting this change: #3626 (comment)