Is there way to translate EF Core query to WITH Queries (Common Table Expressions) ?

[torgashov]

Hello!
Is there way to translate EF Core query to WITH Queries (Common Table Expressions) ?
(WITH RECURSIVE)
Here is documentation:
https://www.postgresql.org/docs/current/queries-with.html

Is there a way extend EF Core or EF Core PgSQL provider?
When i looked into classes:
NpgsqlQuerySqlGeneratorFactory,
NpgsqlQuerySqlGenerator

as a variant is to override method VisitExtension, but there is a comment:
This is an internal API that supports the Entity Framework Core infrastructure ...

Maybe you have extension то extend this functions?

Can you help me?

[roji]

Duplicate of dotnet/efcore#26486

[roji]

Building support for CTEs needs to happen in EF itself, and isn't a small task - this is something I hope we'll tackle for EF 10. In the meantime, I suggest simply using SQL queries instead of LINQ.

[torgashov]

Thank you for your answers!