Improve performance of `array_position` with scalar needle

### Is your feature request related to a problem or challenge?

`array_position` with a scalar needle could be optimized in a similar way to `array_has`, which would probably yield a big speedup.

### Describe the solution you'd like

_No response_

### Describe alternatives you've considered

_No response_

### Additional context

_No response_