Support identifying when an aggregate function is duplicate-insensitive

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

For #22594, it would be helpful to know when an aggregate function is duplicate-insensitive; of the built-in aggregates, at least `min`, `max`, `bit_and`, `bit_or`, `bool_and`, `bool_or`, and probably `first_value` / `last_value`.

This might also be helpful for other query optimization passes.

### Describe the solution you'd like

_No response_

### Describe alternatives you've considered

_No response_

### Additional context

_No response_