Implement `array_has` function

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

## Summary

| Characteristic | Description |
| --------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Function name: | `array_has` |
| Aliases: | `list_has`, `array_contains`, `list_contains` |
| Original function?: | No |
| Function Description: | Azure DataBricks: Returns true if array contains value. Clickhouse: Checks whether the ‘arr’ array has the ‘elem’ element. Returns 0 if the element is not in the array, or 1 if it is. DuckDB: Returns true if the list contains the element. |
| Sources: | [Concept](https://github.com/apache/arrow-datafusion/discussions/6855) [Azure](https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/functions/array_contains) [ClickHouse](https://clickhouse.com/docs/en/sql-reference/functions/array-functions#hasarr-elem) [DuckDB](https://duckdb.org/docs/sql/functions/nested) |

## Examples:

```
select array_has([1, 2, 3, 4], 3);
----
true
```

```
select array_has([1, 2, 3, 4], 5);
----
false
```


### Describe the solution you'd like

_No response_

### Describe alternatives you've considered

_No response_

### Additional context

_No response_

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Implement `array_has` function #6977

Is your feature request related to a problem or challenge?

Summary

Examples:

Describe the solution you'd like

Describe alternatives you've considered

Additional context

Metadata

Assignees

Labels

Type

Fields

Projects

Milestone

Relationships

Development

Characteristic	Description
Function name:	`array_has`
Aliases:	`list_has`, `array_contains`, `list_contains`
Original function?:	No
Function Description:	Azure DataBricks: Returns true if array contains value. Clickhouse: Checks whether the ‘arr’ array has the ‘elem’ element. Returns 0 if the element is not in the array, or 1 if it is. DuckDB: Returns true if the list contains the element.
Sources:	Concept Azure ClickHouse DuckDB

Implement array_has function #6977

Description

Is your feature request related to a problem or challenge?

Summary

Examples:

Describe the solution you'd like

Describe alternatives you've considered

Additional context

Metadata

Metadata

Assignees

Labels

Type

Fields

Projects

Milestone

Relationships

Development

Issue actions

Implement `array_has` function #6977