Calling T-SQL's "PERCENTIlE_CONT" directly from EntityFramework Core

Question

This SO question describes how to call DatePart function using EntityFramework:

I wonder if I can provide a similar binding for PERCENTILE_CONT.

Or maybe the only way to use PERCENTILE_CONT via EntityFramework is to have a stored procedure and call it from my EF code?

• Charlieface: You could probably build it off the RowNumberExpression source code, see github.com/dotnet/efcore/blob/main/src/EFCore.Relational/Query/…
• LA.27: Thanks. I tried creating something like this, but I've got hard time trying to call it. Do you have any resources on adding custom extensions into EntityFramework? I've tried googling myself, but most likely I use wrong phrase.
• Svyatoslav Danyliv: Don't be so optimistic, even you create RankExpression, you will need to replace SqlBuilder (whatever it is named in EF Core)