Unaggregated sub-query over array property in `SELECT`

[tastott]

Currently you can do this:

SELECT
    (SELECT COUNT() FROM SomeArrayProperty) AS Count
FROM
    'file://...'

However, you should also be able to do this:

SELECT
    (SELECT Blah AS Thing FROM SomeArrayProperty) AS TransformedStuff
FROM
    'file://...'