title: column "statement_date" is of type date but expression is of type integer
body: <p>Consider the following query:</p>
  
  <pre><code>INSERT INTO     statement_line_items
  SELECT      count(*)::integer as clicks, sum(amount_cents)::integer as amount_cents, imps.user_id, imps.created_at::date as statement_date
  FROM        impression_events imps
  INNER JOIN  transactions t ON t.event_id = imps.id
    AND       t.event_type = 'ImpressionEvent'
    AND       amount_cents &gt;= 0
  WHERE       imps.created_at &gt;= (now() - interval '8 days')::date
    AND       imps.created_at &lt; (now() - interval '7 day')::date
    AND       imps.clicked = true
  GROUP BY    imps.user_id, imps.created_at::date;
  </code></pre>
  
  <p>This is returning:</p>
  
  <pre><code>ERROR:  column "statement_date" is of type date but expression is of type integer
  LINE 2: ...icks, sum(amount_cents)::integer as amount_cents, imps.user_...
                                                               ^
  HINT:  You will need to rewrite or cast the expression.
  
  ********** Error **********
  
  ERROR: column "statement_date" is of type date but expression is of type integer
  SQL state: 42804
  Hint: You will need to rewrite or cast the expression.
  Character: 117
  </code></pre>
  
  <p>My table structure for statement_line_items is: </p>
  
  <pre><code>"id";              "integer"
  "user_id";         "integer"
  "statement_date";  "date"
  "description";     "character varying(255)"
  "clicks";          "integer"
  "amount_cents";    "integer"
  "created_at";      "timestamp without time zone"
  "updated_at";      "timestamp without time zone"
  </code></pre>