title: Databricks "extraneous input expecting EOF" error
body: <p>This took me a while to figure out so I thought I'd share to save someone else the pain. This is obviously dummy code to illustrate the issue.</p>
  <p>This doesn't work:</p>
  <pre><code>%sql
  
  Select 'A' as A -- I won't need this
    , '1' as B;
  
  Select 'Magic';
  </code></pre>
  <p>Error message:</p>
  <pre><code>Error in SQL statement: ParseException: 
  extraneous input 'Select' expecting {&lt;EOF&gt;, ';'}(line 4, pos 0)
  
  == SQL ==
  Select 'A' as A -- I won't need this
    , '1' as B;
  
  Select 'Magic';
  ^^^
  </code></pre>
  <p>This does work:</p>
  <pre><code>%sql
  
  Select 'A' as A -- I wont need this
    , '1' as B;
  
  Select 'Magic';
  </code></pre>
  <p>And the difference in the single-quote in the comment on line 3.</p>