Optimize array_has() for scalar needle #20377
Description
Is your feature request related to a problem or challenge?
For the scalar needle case, array_has is reasonably fast but it could be optimized by avoiding the per-row work that is currently done to construct the result set (construct a slice into a BooleanArray and count the set bits).
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response