[Task]: Use Timestamp logical type in Beam SQL #40454

What needs to happen?

Default SQL TIMESTAMP to Timestamp.MICROS (or equivalent) instead of FieldType.DATETIME once Beam SQL / Calcite can preserve microsecond precision end-to-end.

Issue Priority

Priority: 2 (default / most normal work should be filed as P2)

Issue Components

• Component: Python SDK
• Component: Java SDK
• Component: Go SDK
• Component: Typescript SDK
• Component: IO connector
• Component: Beam YAML
• Component: Beam examples
• Component: Beam playground
• Component: Beam katas
• Component: Website
• Component: Infrastructure
• Component: Spark Runner
• Component: Flink Runner
• Component: Prism Runner
• Component: Twister2 Runner
• Component: Hazelcast Jet Runner
• Component: Google Cloud Dataflow Runner