[ESQL] SimplifyComparisonArithmetics not being correctly applied

[not-napoleon]

Elasticsearch Version

main

Installed Plugins

No response

Java Version

bundled

OS Version

n/a

Problem Description

The SimplifyComparisonArithmetics optimization rule isn't being applied everywhere we expect. We see this as test failures for cases that should be optimized by this rule. There are several related issues, this one is about failures related to using the QL Neg and Sub classes, instead of the ES|QL versions, in the mentioned optimization.

Steps to Reproduce

Run the SQL tests (soon to be ported to ES|QL)

Logs (if relevant)

No response

[elasticsearchmachine]

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