[Feature Request]: Support CTE statement entity collection

[JackWang032]

Topic

Enhance existing features

Description

The temporary result set created in a CTE statement can be collected.

WITH sales_data AS (
    SELECT product_id, SUM(amount) AS total_sales
    FROM orders
    WHERE order_date >= '2023-01-01'
    GROUP BY product_id
),
top_products AS (
    SELECT product_id, total_sales
    FROM sales_data
    WHERE total_sales > 10000
)
SELECT p.name, tp.total_sales
FROM top_products tp
JOIN products p ON tp.product_id = p.id
ORDER BY tp.total_sales DESC;