title: Proper way of dealing with lists in parameters of raw query in EF core with postgresql
body: <p>What is the right way of dealing with list of items which I need to include in WHERE IN query? In my use case, I need to use list of DateTimes. My current solution is pretty awful because I embedded data in query and I would prefer to use query parameters.</p>
  
  <pre><code>            var n = String.Join(",", dates.Select(item =&gt; $"'{item.ToString()}'::timestamp"));
              var q = $@"
  SELECT c.date AS date, a.id AS user_id, a.user_name AS user_name, a.email AS user_email, COALESCE(sum(te.amount), 0) AS summary
  FROM asp_net_users a
           CROSS JOIN (SELECT *
                       FROM calendar
                       WHERE date IN({n})
  ) c
           LEFT JOIN time_entries te on a.id = te.user_id AND c.date = te.date
  WHERE a.department_guid = '95b7538d-3830-48d7-ba06-ad7c51a57191'
  GROUP BY c.date, a.id
  HAVING COALESCE(sum(te.amount), 0) &gt; 480
  ORDER BY c.date
  ";
  </code></pre>
  
  <p>When I try to use dates as array in query parameter I receive following error:</p>
  
  <pre><code>operator does not exist: timestamp without time zone = timestamp[]
  </code></pre>