This is an enhancement request to add full support for implicit join on collection and get the feature documented.
select p.address from Person (currently supported)
Then new requirement come in for the business to have many addresses.
Then query become naturally:
select p.addresses from Person (currently almost working, but crash with query cache)
We have seen that in real world application.