Date type mapping from AVRO to Beam Schema produces invalid schema when used with Beam SQL

[damccorm]

The date type mapping in AvroUtils (introduced in #9152) produces DATETIME fields for AVRO fields with logical type date. Beam SQL expects LOGICAL_TYPE/Date for DATE fields, which was introduced after the AvroUtils mapping was made.

Imported from Jira BEAM-11323. Original Jira may contain additional context.
Reported by: sjvanrossum.