Does EF Core/Npgsql have a way to translate a LIKE ANY statement?
For example, translating from this:
IQueryable<string> source; // => "cat"
string[] items = new string[] { "a", "b", "c" };
source.Where(x => items.Any(x.StartsWith));
to this:
WHERE 'cat' LIKE ANY('{a%,b%,c%}');
Does EF Core/Npgsql have a way to translate a
LIKE ANYstatement?For example, translating from this:
to this: