[feature] implement WITH (Common Table Expressions)

[BohuTANG]

Summary

MySQL 8.0 CTE:

WITH
  cte1 AS (SELECT a, b FROM table1),
  cte2 AS (SELECT c, d FROM table2)
SELECT b, d FROM cte1 JOIN cte2
WHERE cte1.a = cte2.c;

https://dev.mysql.com/doc/refman/8.0/en/with.html#common-table-expressions

[tlightsky]

this feature is cool,
will vecotrsql have the same storage fromat as clickhouse btw?

[BohuTANG]

this feature is cool,
will vecotrsql have the same storage fromat as clickhouse btw?

Yes, it is preferred.