title: Calling a script function in a QUERY statement
body: <p>In the QUERY "select" clause it states that you can use a scalar function in place of 
  a column name, for example "year(A)".</p>
  
  <p>And in another part of the documentation it states that you can call a script 
  function by coding "=function_name(...)" into the cell.</p>
  
  <p>My question is: can you use a script function as a "scalar function" in a QUERY
  statement?</p>
  
  <p>If possible, it would greatly simplify code and might improve performance,
  for some cases, for example "copying data from one sheet to another".</p>
  
  <p>Here is my example</p>
  
  <pre><code>Assume "test" is a function that issues a "return" statement that modifies
  its input parameter.  
  </code></pre>
  
  <p>I have tried the code  </p>
  
  <pre><code>=test(A1)
  </code></pre>
  
  <p>in a cell and it works.</p>
  
  <p>But when I try this QUERY </p>
  
  <pre><code>=QUERY(A1:A10, "select test(A)" )
  </code></pre>
  
  <p>it fails. My guess it does not like the "test(A)" value. 
  Is there some way to do this.</p>