Using INCLUDE NULLS with UNPIVOT in BigQuery

While solving a bug I was reminded again that, when UNPIVOTing, rows with NULL values are excluded. Fine. But it turns out we have the option to specify the INCLUDE NULLS with UNPIVOT, thus allowing us to keep those rows in the result set. Let's look...