title: How to select all columns except one or two from a table
body: <p>Given a table containing col_1 through col_50 how would I change this query to return new_col and col_1 through col_49?</p>
  
  <pre><code>select tmp_col + 10 as new_col, *
  from (
      select col_1 / col_2 + col_3 as tmp_col, *
      from table
  ) t
  </code></pre>
  
  <p>I don't want tmp_col and col_50. This query needs to run on several tables with slightly varying names so I need to use the star instead of listing out the column names.</p>