Is it possible to select where value is not in multiEntry column?

[crstffr]

I have come across a need to select rows that do not have a value in a multiEntry column. Essentially, I want to exclude rows that have a given tag.

I tried something like this, where I am looking to get results that do not have the "mongo" tag (example here adapted from your multiEntry example). Unfortunately, it performs an exact "not equals" match, and does not look into the values in the array.

const results = await connection.select({
  from: 'people',
  where: {
    tags: {'!=': 'mongo'}
  }
});

Is it possible to select where a value is not in a multiEntry column?

Thanks for your help,
Chris