title: NHibernated Generated Select Query has Too Many Projections
body: <p>I have an NHibernate detached criteria query which has a couple of inner joins, and when I get its generated SQL statement it seems to have a lot of columns in the projection which I don't actually need. The most annoying thing is this makes a significant performance  impact.</p>
  
  <p>for instance a generated query may look like</p>
  
  <pre><code>    select a.a, a.b, a.c .... a.z,
      b.a, b.b, b.c .... b.z
      from ...
      where...
  </code></pre>
  
  <p>But what I am actually trying to get at is</p>
  
  <pre><code>    select a.*
      from ...
      where...
  </code></pre>
  
  <p>I have tried to locate any resources that might help me solve this by using result transformers or other methods since I my knowledge on the criteria api is quite immature. </p>
  
  <p>Is this possible ? </p>