diff options
| -rw-r--r-- | examples/bigquery_view_parser.py | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/examples/bigquery_view_parser.py b/examples/bigquery_view_parser.py index 3ab13f3..9215225 100644 --- a/examples/bigquery_view_parser.py +++ b/examples/bigquery_view_parser.py @@ -1775,6 +1775,12 @@ if __name__ == "__main__": (None, 'bigquery-public-data:samples', 'wikipedia'), ] ], + [ + """\ + with t as (select CASE when EXTRACT(dayofweek FROM CURRENT_DATETIME()) == 1 then "S" end) select * from t + """, + [], + ], ] # fmt: on |