You can create dynamic relationships — this relationship is based on a column that's added using a subquery, in a scope

You can create dynamic relationships — this relationship is based on a column that's added using a subquery, in a scope

And so much more.