I think it would be technically possible, I would be just very worried about the performance of such a query (*-to-many with default auditing strategy), as it would have to involve many correlated subqueries.

Validity should be much better here.