Feature: allow inclusive range query (array as id) where you only have to specify first elements and succeeding with NONE

[Zercerium]

Is your feature request related to a problem?

the query SELECT * FROM temp:['London',NONE]..=['London',NONE] currently returns nothing.

See also #3711

Describe the solution

It would be convenient if this query returns all entries where the first entry in the array is London.
You don't always know the max possible value which the second entry could be (or you have to query it first, but in this case you can directly use WHERE, performance wise I think) for example if it is a uuid or dates in the future, where you could only speculate the max value.

Alternative methods

select * from temp where id[0]="London"
this query works as intended but the mentioned method above would be a bit more convenient

SurrealDB version

surreal 1.3.0

Contact Details

No response

Is there an existing issue for this?

• I have searched the existing issues

Code of Conduct

• I agree to follow this project's Code of Conduct