Support for Array Operators

[aemonm]

It would be nice to have array operator support as outlined here.
Array Operators: (http://www.opengis.net/spec/cql2/1.0/conf/array-operators) defines array operators (A_EQUALS, A_CONTAINS, A_CONTAINED_BY, and A_OVERLAPS)

We are specifically hoping to support an intersection check equivalent to something like:
SQL SELECT * FROM some_table t WHERE someClientArray && t.db_array // check to see if there's at least one value in common

[jonaraphael]

@vincentsarago ,
I've been working with David Bitner to try to figure out another way to process arrays through the CQL-2 JSON filter. Our desired line of SQL is this:
WHERE 4485 = ANY(source_type_1_ids)
(4485 is a user-provided bigint, and source_type_1_ids is a bigint[] column)

He suggested two ways to do this:

1. {'op': 'any', 'args': [{'property': 'source_type_1_ids'}]}
   returns Unable to parse expression node {'op': 'any', 'args': [{'property': 'source_type_1_ids'}]}

2. {"op":"in", "args":[4485,{"property": "source_type_1_ids"}]}
   returns {"detail":"'Attribute' object is not iterable"}

Can you tell me what the correct syntax to execute this functionality is?
If this SQL functionality is not currently supported by TiPG, do you have a sense of level of effort / time it would take to support it?

Thank you!

(Also, sorry David, if this is the wrong place to post this question!)