translate query correctly for multi-value list columns when using NOT HAS

Description

Showed to Ziming, and he thinks it's a bug so I'm opening an issue to track. This is something that I ran into while working on the CRC researcher portal, but this bug is not critical (as a workaround I'll use a different condition that should work well enough).

Here's the example where I saw it:
SELECT * FROM syn22154087 where dataGroups NOT HAS ('test_user')

Environment

None

Assignee

Ziming Dong

Reporter

Jay Hodgson

Labels

None

Validator

Jay Hodgson

Development Area

None

Release Version History

None

Fix versions

Priority

Major
Configure