Filter entities based on their related items characterestics.

[karatakis]

Motivation

Allow to query parent entities based on the characteristics of their related entities properties.

For example this query:

SELECT `artists`.* FROM `artists`
JOIN `tracks` ON `artists`.`id` = `tracks`.`artist_id`
ON `tracks`.`duration` > 300
GROUP BY `artists`.*

We can fetch all the artists that have songs with duration greater than 5 minutes.

Proposed Solutions

Extend the query and filter input module

Additional Information

Nothing so far.