Add built-in table function for generating sequence of dates

[piotrrzysko]

I’d like to propose adding a built-in table function that returns a sequence of dates, similar to the existing sequence function for bigints.
The scalar counterparts of sequence for both bigints and dates share the same name. Since, table functions currently do not support overloading I see two possible approaches:

1. Assign a unique name to the new function, e.g., date_sequence.
2. Add support for overloading table functions. Based on my understanding, the SQL spec allows overloading table functions.

For reference, here’s a Slack thread discussing this: https://trinodb.slack.com/archives/C07ABNN828M/p1736797358292709

[mosabua]

Fyi @kasiafi and @martint

Also @piotrrzysko can you add some of the ideas and points form the slack discussion here since that thread will disappear.