title: REGEXP_CONTAINS not recognized
body: <p>Happy new years, stackoverflow!</p>
  
  <p>I am trying to use some regex functions in bigquery but some of them return error as if I have the name wrong.</p>
  
  <pre><code>SELECT REGEXP_CONTAINS(path, r'^abc$') FROM [tablename]
  
  Query Failed
  Error: 2.24 - 2.26: Unrecognized function regexp_contains
  </code></pre>
  
  <p>Where as if I do a similar regex function, the function text in the editor changes color and the query works.</p>
  
  <pre><code>SELECT REGEXP_EXTRACT(path, r'^abc$') FROM [tablename]
  </code></pre>
  
  <p>It should work since it's documented in this <a href="https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#regexp_contains" rel="nofollow noreferrer">link</a>.</p>
  
  <p>Does anyone know how to fix this?</p>