text: Title: Add support for `@db.Date` fields
  Body: ## Problem
  
  <!-- A clear and concise description of what the problem is. Ex. I'm always frustrated when [...] -->
  
  We don't currently support `DateTime` fields that represent `Date`s at the database level because we generate a `datetime.datetime` type instead of `datetime.date` which results in failed Pydantic validation.
  
  ```prisma
  date DateTime @default(dbgenerated("CURRENT_DATE")) @db.Date
  ```
  
  ## Suggested solution
  
  <!-- A clear and concise description of what you want to happen. -->
  
  This is essentially blocked on https://github.com/prisma/prisma/issues/3998 unfortunately...
  