[Feature Request]: Support CTE statement entity collection

### Topic

Enhance existing features

### Description

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

```sql
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;
```

該 issue 未提供檔案、測試或進入點。首先定位現有的實體集合處理邏輯，以及針對所示 SQL 形式的 CTE 解析；完成的標準應是能夠收集由 CTE 陳述式建立的暫存結果集。

由索引模型根據 Issue 內容生成。