title: BigQuery save OPTIONS(strict_mode=FALSE) in procedure
body: <p>I have procedure below which create procedure in different projects</p>
  <pre><code>    CREATE OR REPLACE PROCEDURE `sp_get_data`(arg_ProjectID STRING, arg_DatasetID STRING)
  OPTIONS(strict_mode=FALSE)
      BEGIN
      EXECUTE IMMEDIATE
          &quot;CREATE OR REPLACE PROCEDURE `&quot;|| arg_ProjectID || &quot;.&quot; || arg_DatasetID || &quot;.sp_get_data_details`()                                             \r\n&quot;||
          &quot;BEGIN 
      -- lengthy code
      &quot;END&quot;                                                                                                                                                                                                                                                                                                                                                       
          ;       
      END;
  </code></pre>
  <p>The code insde procedure is very very lengthy.</p>
  <p>When I run this create procedure with <strong>OPTIONS(strict_mode=FALSE)</strong>, it is working..., but it doesn't not save in procedure script..
  how to make it persist in procedure script</p>
  <p>without it throws error</p>
  <blockquote>
  <p>Query error: Out of stack space due to deeply nested query expression
  during query resolutio</p>
  </blockquote>
  <p>But how can I add this dynamically when calling like</p>
  <p><strong>call sp_get_data(projectid,datasetid)</strong></p>
  <p>Any help,
  Highly appreciated</p>