title: BigQuery: How to call a stored procedure in where clause?
body: <p>I have a stored procedure <code>compare()</code> that compares two strings and returns <code>true</code> or <code>false</code>. I want to use this procedure in aggregation like in the following statement:</p>
  <pre><code>SELECT * 
  FROM myTable AS t1
  INNER JOIN myTable2 AS t2
  WHERE compare(t1.column1, t2.column2)
  </code></pre>
  <p>But I'm getting the following error:</p>
  <blockquote>
  <p>Procedure is not supported in this context</p>
  </blockquote>
  <p>Is there any hack to call stored procedure in the aggregation of a SQL statement?</p>