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.