Koen

At first glance, it seems that this could be implemented here: https://github.com/OrleansContrib/OrleansDashboard/blob/4b9dd9ed86038a0a6b254cc2ce5c8dfb6edbeb2b/OrleansDashboard/Implementation/Helpers/GrainStateHelper.cs#LL67C1-L67C1 Happy to issue a PR if there is an agreement that this is valuable.

I'm unable to reproduce this: ```sql SELECT [u].[Id], [u].[SendMoneyAt], [u].[UserName] FROM [User] AS [u] WHERE [u].[Id] IN ( SELECT [u0].[Id] FROM [User] AS [u0] WHERE [u0].[UserName] LIKE N'%A%' ) ```...

The culprit here is this line: `backerUsers.Where(u => usersWithLetterA.Contains(u.Id));` where if `u.Id` was a projectable property then it would throw this error

Since #124 has been merged, this should now be fixed

Can you clarify what is not working? https://github.com/koenbeuk/EntityFrameworkCore.Projectables/blob/issue/123/tests/EntityFrameworkCore.Projectables.FunctionalTests/DbFunctionTests.cs translates just fine.

There is a regression with supporting `IAsyncEnumerable` with this PR. Will fix that regression and in turn, try and fix #8958

The biggest blocked here would be an analyzer with a code-fix to help migrating from V3 to V4. I'm hoping to get that implemented within the next 2 weeks.