BigQuery で WHEN CASE 文が書けない時の対処法 ref: http://qiita.com/Yinaura/items/5cfab23d32a57c259a5c

file0.sql

SELECT
 CASE fruit
   WHEN 'Apple' THEN 'is apple'
   WHEN 'Orange' THEN 'is orange'
   ELSE 'none'
END AS fruit_kind;

file1.txt

Query Failed
Error: searched case expression not supported at: 

file2.sql

SELECT
 CASE
   WHEN fruit = 'Apple' THEN 'is apple'
   WHEN fruit = 'Orange' THEN 'is orange'
   ELSE 'none'

file3.txt

Row fruit_kind   
1   is apple