Description

I have a column with array type

:tags INT[]

and I need to check if array contains any of elements

WHERE tags @> :tags

It is essentially IN query but for arrays.

https://www.postgresql.org/docs/current/functions-array.html
https://stackoverflow.com/a/54069718

similar to what was done for json type #3009