Allow custom table aliases for column alias injection from multiple tables in native SQL
Description
When you use the "{entity.*}" syntax in a native SQL query to let NHibernate create all column aliases, columns for all <join> and <joined-subclass> elements are also created. But this columns always use table aliases which are like "entity_1_", "entity_2_" and so on when the alias for the main table is "entity".
This is not only hard to read in the query but also very unhandy if your main entity has multiple <join> and/or <joined-subclass> elements mapped because you have to run the query once to know what alias NHibernate will use for what table.
When you use the "{entity.*}" syntax in a native SQL query to let NHibernate create all column aliases, columns for all <join> and <joined-subclass> elements are also created. But this columns always use table aliases which are like "entity_1_", "entity_2_" and so on when the alias for the main table is "entity".
This is not only hard to read in the query but also very unhandy if your main entity has multiple <join> and/or <joined-subclass> elements mapped because you have to run the query once to know what alias NHibernate will use for what table.