sql: query works in Postgres but not CockroachDB

[RichardJCai]

This was found during Hack the North, a hacker found that the following setup/query would work on PG13 but not CRDB.

Setup

drop table if exists pplArr;
create table pplArr(uid text primary key, languages text[]);
insert into pplArr (uid, languages) values
('allen','{go,python,java,swift}'),
('em','{python,java,swift}'),
('aman','{go,python,java}'),
('harp','{python,java,swift}');

Query

select uid, count(lang) as common_elements
from pplArr p
cross join unnest(p.languages) as lang
where lang = any('{go,java,python}')
group by 1;

The query succeeds in PG but gives ERROR: no data source matches prefix: p in this context in CRDB

[rafiss]

closing in favor of #70342