For queries that group by a date, keeping the column as a date is much
faster than converting it to a string. I wouldn’t be surprised if this
is true for all databases; it is definitely true for Snowflake. Here’s
an example: select date_trunc('month'...