WITH Clause in the Query Builder

[Neo-Zhixing]

Issue type:

[x] question
[ ] bug report
[x] feature request
[ ] documentation issue

Database system/driver:

[ ] cordova
[ ] mongodb
[x] mssql
[ ] mysql / mariadb
[x] oracle
[x] postgres
[ ] sqlite
[ ] sqljs
[ ] react-native
[ ] expo

TypeORM version:

[x] latest
[ ] @next
[ ] 0.x.x (or put your version here)

Is it possible to create queries with "WITH Clause" using the query builder?

Like this:

WITH regional_sales AS (...subquery... )
SELECT region,
       product,
       SUM(quantity) AS product_units,
       SUM(amount) AS product_sales
FROM regional_sales 

[Kononnable]

#1116

[Prafull1Kumar]

I have the same problem.