More general alias options in SQLProjection

[Roy.Jacobs]

Hi,

I am using QueryOver to do some querying. However, I need to do some simple arithmetic in my query (multiply two columns) and due to legacy constraints and so on, I need to do this directly in my query and cannot simply add a calculated column in the database.

Since QueryOver doesn't directly support these arithmetic operations, I am using an SQLProjection. Currently it seems that the only alias that can be used in an SQLProjection is "{alias}" which refers to the root table of the criteria (typically "this_").

Now, because of some overlapping column names I would also like to be able to specify the column names of joined tables. I have given the joined table aliases which I can indeed use in the rest of my QueryOver, but the SQL table aliases that are generated by NHibernate are decorated and truncated so I cannot directly use my alias names in the projection (e.g. a table "FooBarBazBoo" will become something like "foobarba3_".

Are there any plans to extend the alias support in SQLProjection to allow the use of joined tables? If not, is this due to lack of time, or is it simply by design (and I shouldn't bother trying to add this feature)?

Thanks,

Roy