SQL: NOT translated to Lucene query doesn't handle 3vl

[matriv]

e.g.

SELECT last_name l FROM "test_emp" WHERE languages NOT IN (2, 10) AND (emp_no = 10018 OR emp_no = 10019 OR emp_no = 10020) ORDER BY emp_no;

returns also Warwick which is an entry with null for languages.
for this entry: null NOT IN(2, 10) => NOT (null in (1, 2)) => NOT(null) => true but it should be:
NOT(null) => null => false

[elasticmachine]

Pinging @elastic/es-search-aggs

[matriv]

@elastic/es-ql

[elasticsearchmachine]

Pinging @elastic/es-analytical-engine (Team:Analytics)