[Bug] Microbatch does not work with date field types

[jschintz-nytimes]

Is this a new bug in dbt-bigquery?

• I believe this is a new bug in dbt-bigquery
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

When configuring microbatch incremental strategy, if the upstream event_time field is a date - an error is returned:
Could not cast literal "2024-11-11 00:00:00+00:00" to type DATE

Expected Behavior

Should the event_time field should be cast to a datetime datatype to handle issues where

Steps To Reproduce

1. Make an upstream microbatch that outputs a date(event_time) partitioned column.
2. Query in a downstream model that is also microbatch.

Relevant log output

No response

Environment

- OS:
- Python:
- dbt-core:
- dbt-bigquery:

Additional Context

No response