[FEATURE] Add "between" expression to PPL

[A-Gray-Cat]

Is your feature request related to a problem?
When doing comparisons for a range, it will be very convenient to have a between command, e.g.

Instead of writing, ... | where datetime >= '2024-09-10' and datetime <= '2024-09-15', it can be written as ... | where datetime between '2024-09-10' and '2024-09-15'.

What solution would you like?
Add the "between" expression. This is a nice to have.

What alternatives have you considered?
A clear and concise description of any alternative solutions or features you've considered.

Do you have any additional context?
Add any other context or screenshots about the feature request here.

[YANG-DB]

@salyh Can u plz review and validate this issue ?
thanks

[salyh]

It's a valid request albeit its only syntactic sugar. Spark SQL does have a BETWEEN function so it makes sense.

@A-Gray-Cat @YANG-DB I suggest to implement it like expr1 [NOT] BETWEEN expr2 AND expr3 - evaluate if expr1 is [not] in between expr2 and expr3. exactly like Spark SQL is implementing it (https://spark.apache.org/docs/latest/api/sql/#between)

[dblock]

[Catch All Triage - 1, 2, 3, 4]

[YANG-DB]

It's a valid request albeit its only syntactic sugar. Spark SQL does have a BETWEEN function so it makes sense.

@A-Gray-Cat @YANG-DB I suggest to implement it like expr1 [NOT] BETWEEN expr2 AND expr3 - evaluate if expr1 is [not] in between expr2 and expr3. exactly like Spark SQL is implementing it (https://spark.apache.org/docs/latest/api/sql/#between)

@salyh agree lets proceed with the suggested syntax
please add this suggestion to the ppl planning list