How to use Common Table Expressions ?

[torgashov]

Hello!
We use LINQKit with EF Core for PgSQL, which allows the With...AS code construct to reuse subqueries.
We have a table with a self-join and need to read data recursively.
How to use Common Table Expressions with LINQKit as the equivalent AsCte() method in LINQtoDB?
Or maybe LINQKit has the ability to create recursive database queries without loading the data to the client (when using IEnumerable)?