Cte support

[matt-psaltis]

Hi there just wondering if there's any plans to support ctes (common table expressions)

[JonathanMagnan]

Hello @SaltyDH ,

Do you have something specific in mind? What exactly you would like we add with CTE?

We are supposed next week to bring the feature ToSelfHierarchyList in EF Classic which used CTE: https://entityframework-extensions.net/to-self-hierarchy-list

Best Regards,

Jonathan

[matt-psaltis]

Something along the lines of this. https://linq2db.github.io/articles/sql/CTE.html

We use it for a variety of bespoke queries to provide the main query with additional data.

[JonathanMagnan]

Look great,

We will for sure look at it next week and see if there is anything we can do.

[tsanton]

@JonathanMagnan did you ever look into this issue?

[JonathanMagnan]

Hello @tsanton ,

It might eventually happen, but this is currently not on our priority list at all.

We surely started to use CTE for some features we recently added, like WhereBulkContains, but still do not provide a direct way of using it.

Best Regards,

Jon