title: How to use select statements for column name ending in +
body: <p>I am attempting to run a spearman correlation on some data under the column name solar+. However, when attempting to use select statements to select the desired number of rows from the egauge13830 table, the plus sign is considered an operator and causes an error. These are the 2 statements I've tried and their results:</p>
  
  <p>1)</p>
  
  <pre><code>sql1 = """    
  SELECT solar+    
  FROM egauge13830    
  WHERE tstamp &lt; 1434870960    
  """
  </code></pre>
  
  <p>sqlalchemy.exc.ProgrammingError: (psycopg2.errors.SyntaxError) syntax error at or near "FROM"</p>
  
  <p>LINE 3: FROM egauge13830</p>
  
  <pre><code>      ^
  </code></pre>
  
  <p>2)</p>
  
  <pre><code>sql1 = """    
  SELECT 'solar+'    
  FROM egauge13830    
  WHERE tstamp &lt; 1434870960    
  """
  
  df1 = pd.read_sql_query(sql1, engine)    
  print(df1.head())
  
  0   solar+    
  1   solar+    
  2   solar+    
  3   solar+    
  4   solar+
  </code></pre>
  
  <p>I have also attempted changing the name of this column, but can't find a way to do so which doesn't involve select statements, the use of which causes the exact same problems illustrated above.</p>
  
  <p>So, is there something I can add to the select statement to make it run or another way of changing the column name?</p>
  
  <p>Thanks for any and all help.</p>