Support for Array column filtering

[dimiterpaskov]

Are there plans to add filtering support for Array columns with the has/hasAny/hasAll functions?

[denis-ivanov]

@dimiterpaskov, could you provide an example how you see it in LINQ?

[dimiterpaskov]

I suggest following the approach used by the EF Core PostgreSQL provider:
https://www.npgsql.org/efcore/mapping/array.html

"has({array}, {value})" → array.Contains(x.Value)
"hasAny({array1}, [{array2}])" → array1.Any(i => array2.Contains(i))
"hasAny({array1}, [{array2}])" → array1.Intersect(array2).Any()
"hasAll({array1}, [{array2}])" → array1.All(i => array2.Contains(i))

[moxplod]

Looking for this too.

[denis-ivanov]

@moxplod , #109 (comment)