Watch out when using SAFE_CAST in BigQuery

Here's an interesting situation I've seen with BigQuery. Say a source system provides JSON events with timestamps at microsecond grain (6 decimals, so something like 2024-01-01 14:00:00.123456). This is cast using SAFE_CAST into a proper TIMESTAMP. A...