Bug fix and change filterMany to put predicates into JOIN clause, Fix for #3626

[rbygrave]

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 - Change such that filterMany can be included in the main query. #2222 (version 12.9.0)
• Related Bug 1 - Different filterMany behavior when no matches found #3453 (version 14.5.2)
• Related Bug 2 - filterMany uses id property name instead of id column name on idNullOr #3625 (version 16.0.0)

Issue prompting this change: #3626 (comment)