It could be made available as a level of detail expression, dynamic set, and or
supported in data connections without the use of custom SQL.
It could also be via pass-through (subquery) functions.
I will collect use scenarios as I meet them and share them below:
Please share your use scenarios as comments to this idea.