Short syntax for UNLIST with IN operator #8580
Description
In the original task #8005 (comment) the short syntax FIELD IN UNLIST(..) was considered but it has been postponed. I would like to revive this discussion within this new task.
As it was mentioned in the original discussion there is an example of similar syntax in Google BigQuery SQL with UNNEST https://cloud.google.com/bigquery/docs/arrays
It would be especially useful with automatic "type inference" based on the type of the left expression:
id in unlist(:param)
instead of
id in (select * from unlist(:param) returning bigint)
Also this syntax can be extended to any selectable stored procedure which returns a single column.