When using quantified like operators in BigQuery, we need to use the form LIKE ANY UNNEST(<array>) (docs)
E.g.:
SELECT * FROM (
SELECT 'dog' as word
) sub
WHERE word LIKE ANY UNNEST(ARRAY['d%'])
Currently, this yields a parsing error in this library.
This is different from postgres, where we can just do LIKE ANY <array> (in BQ, this would be a syntax error)
When using quantified like operators in BigQuery, we need to use the form
LIKE ANY UNNEST(<array>)(docs)E.g.:
Currently, this yields a parsing error in this library.
This is different from postgres, where we can just do
LIKE ANY <array>(in BQ, this would be a syntax error)