Derived Tables and Common Table Expressions (CTE)s with Diesel

[jacques-kigo]

Hello!

I'm getting quite into the weeds with trying to do fairly advanced db interactions (I've been posting here quite a lot 😅 thank you @weiznich for all your support and quick responses)

I would like to work with either a derived table or a common table expression, does the Diesel query builder API support such features? And if so can you please point me in the direction of some examples I could follow? I'm trying to keep things as type-safe as possible.

Kindly, Jacques

[weiznich]

I generally do not answer questions if I'm pinged for that question. That's reserved for significant diesel sponsors.

Otherwise I encourage you to just use the search function to get an answer to that question.

[jacques-kigo]

Understood. Thank you!

[jacques-kigo]

Looking at these most recent posts, Derived Tables and Common Table Expressions (CTE)s are not supported by Diesel.

• How do I group by derived columns? Also, are common table expressions supported? #4352
• Common Table Expressions #3857