NebulaQueryAndSearch icon indicating copy to clipboard operation
NebulaQueryAndSearch copied to clipboard

Add NOT conditional operator

Open TrangOul opened this issue 1 year ago • 0 comments

I see not way to introduce NOT operator (not to be confused with NOT IN) in the WHERE part, otherwise than rewriting the query. Example:

WHERE NOT (Industry = 'Agriculture' OR Industry = 'Biotechnology')

cannot be built in this framework; we need to rewrite it as:

WHERE Industry != 'Agriculture' AND Industry != 'Biotechnology'

TrangOul avatar Aug 12 '24 13:08 TrangOul