Hello fellow Metabase enthusiasts,
do you have any hints how to adjust the behavior of the query optimization for temporal filters? When we have a Date column, we cannot compare directly against a DateTime String, but we have to cast to Date or DateTime first. E.g. “WHERE
date_column >= ‘2020-01-31 23:00:00’ AND
date_column < ‘2020-02-29 23:00:00’” query does not work.
Perhaps there is a smarter way to serialize Date values, depending on the field type, in the driver, or there is even a simpler solution to this issue. Please enlighten me!