title: Is there a way to escape and use ColdFusion query reserved words as column names in a query of query?
body: <p>I'm working with a query that has a column named "Date." </p>
  
  <p>The original query returns okay from the database. You can output the original query, paginate the original query, get a ValueList of the Date column, etc.</p>
  
  <p><strong>Query of Query</strong></p>
  
  <pre><code>&lt;cfquery  name= "Query" dbtype= "query"&gt;
  select 
  [Query].[Date]
  
  from [Query] 
  
  &lt;/cfquery&gt;
  </code></pre>
  
  <p><strong>Response from ColdFusion</strong></p>
  
  <blockquote>
    <p>Query Of Queries syntax error. Encountered "Date. Incorrect Select
    List,</p>
  </blockquote>
  
  <p>Typically, I use descriptive names so I haven't run across this issue previously.</p>
  
  <p>In this case, I'm working with a stored procedure that someone else wrote. I ended up modifying the stored procedure to use a more descriptive column name.</p>
  
  <p>I have a service I use for transforming, searching and sorting queries with ColdFusion. I'm curious to know the answer to my original question, so that I can modify my service to either throw a better error or handle reserved words.</p>
  
  <p>Is there a way to escape and use ColdFusion query reserved words as column names in a query of query?</p>