title: How do you print the select statements for the following Slick queries?
body: <p>I would like to find out which of the following queries would be the most efficient for getting a row count on a table, so I'm trying to print out the select statements. I know you can add<code>.selectStatement</code> to a Queryable but don't know if this tells me the complete truth because I'll have to remove the result generating code, e.g. <code>.list.length</code> and replace it with <code>.selectStatement</code>. Slick probably picks up that you are looking for the length and optimises further, so I want to see the select statement for the whole query, including the SQL that will be generated because of the <code>.list.length</code>, or <code>.count).first</code></p>
  
  <pre><code>Query(MyTable).list.length
  
  (for{mt &lt;- MyTable} yield mt).list.length
  
  (for{mt &lt;- MyTable} yield mt.count).first
  </code></pre>