Common Table Expression / WITH Clause

[67726e]

Hello,

This is more a question than an issue, but how can I build a CTE (with) with TypeORM ? Is there a built in feature to do this, or should I use the raw sql query builder ?

Thanks.

See Also: #1116

[danurwijayanto]

At type orm documentation have this, but i still failed to implement it.

https://typeorm.io/select-query-builder#common-table-expressions

Error output is : Property 'addCommonTableExpression' does not exist on type 'SelectQueryBuilder

[AlexMesser]

@67726e see the docs - https://typeorm.io/select-query-builder#common-table-expressions

@danurwijayanto CTEs are supported starting from version 0.3.3.

[67726e]

@AlexMesser - For what it's worth - the "Common table expressions" heading does not exist in the navigation at the start of the documentation page. Looks like it should, as the preceding "Querying Deleted rows" does exist.