title: Working with Interval literal for aliases in Snowflake
body: <p>I have a query like this:</p>
  
  <pre><code>select to_date(current_date - interval 'b.a day') as date from (select 1 as a) as b
  </code></pre>
  
  <p>The expected result should be interval '1 day' which will then calculate the difference between the dates. Instead it throws the following error:</p>
  
  <pre><code>SQL compilation error: syntax error line 1 at position 0 unexpected 'b'.
  </code></pre>