Date filter picker doesn't take column's temporal unit in mind

Describe the bug

We should take datetime column's temporal unit in mind when filtering. Most date picker options don't make sense (and don't work) when trying to apply them to columns with buckets like "Year" or "X of Year".

To Reproduce

Year

1. New > Question > Raw Data > Sample Database > Orders
2. Summarize: Count by Created At: Year
3. Add a filter for "Created At: Year"
4. Most of the filter options don't make sense (e.g. Today or Yesterday)

Month of Year

1. New > Question > Raw Data > Sample Database > Orders
2. Summarize: Count by "Created At: Month of Year" (do not confuse with "Created At: Month")
3. Add a filter for "Created At: Month"
4. Again, most of the filter options don't make sense since "Created At: Month of Year" is rather a Category column now

Information about your Metabase installation

master

Severity

P3

Start by reproducing the issue through New > Question > Raw Data > Sample Database > Orders, using the Created At Year and Month of Year summaries described above. Inspect the date filter picker behavior for these temporal units; done means irrelevant options such as Today and Yesterday are not offered or do not produce invalid filters, with the existing reproduction cases covered by tests.