I want to do a query against some of my entities, but in the SELECT clause I want to have the freedom to define aliased columns of any nature, i.e. "SELECT <myEntity>, <myEntity2>, "Test" as TestColAlias FROM", etc, etc.

Can NHibernate cope with this, and what is the best type of query to do?

pls refer to this :

http://www.hibernate.org/hib_docs/nhibernate/html/manipulatingdata.html

hope it helps

regards,

boonseong

Yes, I am aware of all the available info on CreateSQLQuery and doing aliases, but you can only seem to do it if it relates directly to a mapped entity. I want to have the freedom of putting arbitrary columns in for all kinds of reasons. You may want to just put some arbitrary marker in the resultset to act as a flag or status that doesn't necessarily relate to a persistent class's property.