A way to specify constant/scalar arguments in UDFs

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

Some UDFs may expect a constant/scalar/literal argument, and not allow array inputs.

For example, `arrow_cast`:

https://github.com/apache/datafusion/blob/f27e50c13647efa5292d5ef5b1e4ed6af3015962/datafusion/functions/src/core/arrow_cast.rs#L134-L148

### Describe the solution you'd like

Some way to specify this at the signature level instead of needing this manual handling. This can then centralize the logic across the functions that need this.

### Describe alternatives you've considered

_No response_

### Additional context

Perhaps wire it only into the coercible signatures?