SQL: semantic negation of LIKE and ILIKE

[gramian]

ArcadeDB Version:

ArcadeDB Server v24.5.1-SNAPSHOT (build 11db1796a17bfccb23d22cfa73906fbae9f46338/1714568271787/main)

OS and JDK Version:

Running on Mac OS X 12.7.4 - OpenJDK 64-Bit Server VM 17.0.11 (Homebrew)

To negate a LIKE or ILIKE operator one needs to prepend a NOT operator while typically one can write NOT LIKE or NOT ILIKE ie in Postgres.

Current behavior

SELECT (NOT ('abc' LIKE 'a?c'))
SELECT (NOT ('ABC' ILIKE 'a?c'))

Proposed behavior

SELECT ('abc' NOT LIKE 'a?c')
SELECT ('ABC' NOT ILIKE 'a?c')