Support mode in Aggregation function

[Weijun-H]

Is your feature request related to a problem or challenge?

The most frequent value.

Describe the solution you'd like

D SELECT mode(col) FROM VALUES ([1, 2]), ([1, 2]), ([2, 3]) AS tab(col);
┌───────────┐
│ mode(col) │
│  varchar  │
├───────────┤
│ [1, 2]    │
└───────────┘

-- The function returns either 1 or 2, but not 3
> SELECT mode(col) FROM VALUES (1), (1), (2), (2), (3) AS tab(col);
 1

> SELECT mode(col) FROM VALUES (NULL), (NULL) AS tab(col);
 NULL

Describe alternatives you've considered

No response

Additional context

https://duckdb.org/docs/sql/functions/aggregates#modex
https://docs.databricks.com/en/sql/language-manual/functions/mode.html

[dmitrybugakov]

take

[dmitrybugakov]

Done for primitive/float types, working on bytes/views.

[alamb]

Given #12357 we may want to move this function to some other repo rather than the core

[alamb]

Suggestion: #12254 (comment)

[dmitrybugakov]

Implemented: mode.rs

[alamb]

We are going to implement these in a different repository so closing this ticket to avoid confusion: #12254 (comment)