Roman Artiukhin

> Just to check how it works. And it doesn't work... So let's just drop it for now..

Changing casing in namespace. Smart move...

> I would prefer more generic solution which allows for a sql-function restriction And I would prefer more "more generic solution" which allows for any projection restriction. Something like `Restrictions.Projection(Projections.SqlFunction(...`

> would need to be translated into some comparison expression No. I imagine `Restrictions.Projection` should simply generate bare projection in WHERE statement. It's up to projection to be proper in...

> would be implemented just like following Yeah something like this.. Simply projection generated to SQL without any further modifications. > What would be the result SQL ```sql SELECT *...

> But this is not a valid SQL. Indeed it doesn't work with SQL Server but does work with [PostgreSQL](http://sqlfiddle.com/#!15/fb542/1/0). It was long time ago - I had to generate...

Looks like some old NHibernate version is used as `MultiCriteriaImpl` is obsoleted since v5.2.

Looks like [v8.0.30](https://github.com/nhibernate/nhibernate-core/actions/runs/2975635759) is the latest working version.

Interesting async regen failure. Logs crit: AsyncGenerator.CommandLine[0] One or more errors occurred while opening the project: Msbuild failed when processing the file '/home/runner/work/nhibernate-core/nhibernate-core/src/NHibernate.Test/NHibernate.Test.csproj' with message: /usr/share/dotnet/sdk/6.0.405/Microsoft.Common.CurrentVersion.targets: (2302, 5): There was...

> add support for entity casting in hql. Something like select cast_entity(alias, SublcassEntityName) Hibernate uses `treat` - `treat(alias as SublcassEntityName)`. Series of commits adding this functionality: https://github.com/search?q=repo%3Ahibernate%2Fhibernate-orm+treat&type=commits&s=committer-date&o=asc