[SQL] Support Common Table Expressions

[BohuTANG]

Summary

WITH provides a way to write subqueries for use in a larger SELECT query.
References:
https://www.postgresql.org/docs/8.4/queries-with.html
https://clickhouse.tech/docs/en/sql-reference/statements/select/with/

[l1t1]

not yet. but the error message is wrong

@kylin-gtj:~$ cd fuse
kylin@kylin-gtj:~/fuse$ chmod +x fusequery-v0.4.1-alpha-linux-aarch64
kylin@kylin-gtj:~/fuse$ nohup ./fusequery-v0.4.1-alpha-linux-aarch64 &
[1] 15349
kylin@kylin-gtj:~/fuse$ nohup: 忽略输入并把输出追加到'nohup.out'

kylin@kylin-gtj:~/fuse$ pgrep fuse
2362
15349
kylin@kylin-gtj:~/fuse$ mysql -h127.0.0.1 -P3307
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.1.10-alpha-msql-proxy

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select (number+1) as c1, number/2 as c2 from numbers_mt(10000000) where (c1+c2+1) < 100 limit 3;
+------+------+
| c1   | c2   |
+------+------+
|    1 |    0 |
|    2 |  0.5 |
|    3 |    1 |
+------+------+
3 rows in set (0.00 sec)

mysql> with t as (select (number+1) as c1, number/2 as c2 from numbers_mt(10000000) where (c1+c2+1) < 100 limit 3)select * from t;
ERROR 1105 (HY000): Code: 25, displayText = DataSource Error: Unknown table: 't'.

[xudong963]

close by #7056