Compare a List<string> column with a collection of filter

I want to filter User by a matching Permission List.
I’ve got a
string[] FilterPermission
Then I want to do this
var q = Db.From();

It’s a intersection between the 2 list.
Is it possible?


If Permissions is a complex type like string[] or List<string> then it’s blobbed and can’t be queried from server side SQL unless it’s stored in a PostgreSQL complex array type in which case you’ll be able to utilize its Array Functions and Operators.

If Permissions is a string you can use the different IN queries documented from: