Comment by pocksuppet

Okay, what would your solution look like?

    from cities select state where name='Chicago'

isn't really different from

    cities.filter(x=>x.name=='Chicago').map(x=>x.state)