Using ANY_VALUE() in BigQUERY

Have you ever used ANY_VALUE in BigQuery? It's an aggregate function like SUM or AVG, but it returns a non-deterministic (not random) row from the group. I've been using it in scenarios where there's one value anyway, such as when PIVOTing. WITH inp...