title: ActiveRecord custom SQL result automapping
body: <p>In Castle ActiveRecord, I'm querying against the database with <code>session.CreateSQLQuery(MyQueryString).List()</code></p>
  
  <p>When the result columns of a query do not match 100% to the fields of any of my database tables, I cannot use an ActiveRecord-based class to automap the results into a strongly-typed object.</p>
  
  <p>Is there a way to get the results of an ad hoc query mapped into a custom type (perhaps through ActiveRecord attributes on my target class?) without having to map field-by-field at in the query executing/processing code?  I'm thinking something similar to:</p>
  
  <pre><code>MyQueryResultType[] results = session.CreateSQLQuery(MyQueryString).List().MapFieldsAs&lt;MyQueryResultType&gt;();
  </code></pre>