Ability to only filter inner query

What is the problem or goal the end user is trying to solve or accomplish?

Users want to only filter inner query without affecting the outer query.

How are they solving it currently?

User can use Jinja to filter inner query but the outer query is also filtered

What is the recommended solution by the Customer?

To provide ability to only filter inner query