Enable more datetime generalization functions

[pdobacz]

Having cast(extract(minute from ts) as integer)) supported, there are the following expressions which we can't bucket by at the moment (coming from from Metabase):

day:
  CAST(last_seen AS date)

day of week:
	CASE WHEN (((CAST(extract(dow from last_seen) AS integer) + 1) + 6) % 7) = 0 THEN 7 ELSE (((CAST(extract(dow from last_seen) AS integer) + 1) + 6) % 7) END

week of year:
	ceil((CAST(extract(doy from CAST(date_trunc('week', last_seen) AS timestamp)) AS integer) / 7.0))