search in array column

[moinologics]

Discussed in #861

^{Originally posted by moinologics December 31, 2023}
add support to search in an array column

example -

table users

id	name	blocked_user_ids
1	john	[3]
2	jane	[1,3]
3	bob	[]

resultant query

SELECT name FROM users WHERE {{id}} = ANY(blocked_user_ids)

when id = 1, return jane
when id = 3, return john & jane