Currently there is no way to use subqueries in SelectQuery or ObjectSelect.
So we need a way to do so in Expression API.
Simple version can be implemented like this:
Also we need a way to use expressions from top level query in a subquery. Maybe it can be new expression (like Artist.ARTIST_NAME.enclosing())
In a first iteration this should support EXISTS and IN subqueries.