Allow filters to add join tables to sql queries for filtering.
Let's have Brand entity, and BrandText entity. Text is localisation for each Brand. If there is no BrandText with bt.isPublic and bt.web_id = 123 I wanna filter it globally and not even allow to load Brand entity.
This cannot be solved by using DQL, because I need to affect lazily loaded associations, for example in templates
Accessing $product->brand-> in template should resolve to NULL, when there is no BrandText.isPublic = 1.
This could be solved by allowing filters to add joins to queries. Should I prepare a pull request?