I would like to propose being able to make user defined queries for rule templates.
I'm thinking exposing it from the integrator which could generate the query, and then expose the result to the rules engine. This would create a much more flexible way of making rules, and get us further way from those predefined ones which to be honest are rather lacking, and very much focussed on special cases.
Thanks for the idea. This feature has been evaluated by us and we will not implement at this time.