tools/legacy_sql_tranlsation_helper/sample_sql/sample2.sql (2 lines of code) (raw):
SELECT product, inventory, cast(null as string) as color, FROM `projectid.test.simple_table1`
UNION ALL SELECT product, inventory, color, FROM `projectid.test.simple_table2`