maoxd

[reproduce-github-project](https://github.com/maoxingda/sqlfluff-diff-quality-pre-commit-hook-reproduce)

Not yet, I'm in trouble.

Our SQL does not have this kind of syntax. I just found this syntax when looking at the underlying sqlfluff, so I brought it up. Can be processed or not.

**Reference other similar products, for example: [https://sqlflow.gudusoft.com/#/](https://sqlflow.gudusoft.com/#/%22%E3%80%82)**

**Giving aliases t3 and t4 to cte1 and cte2 respectively does not yield the correct results.** ```sql insert into public.t3 ( c1 ) with cte1 as ( select t1.c1 from...

**When using the Redshift dialect and there is a 'join_clause' in the 'from_clause' of the 'set_expression,' the lineage is also incorrect.** ```sql insert into public.tgt_tbl1 ( id ) with cte1...

**Does the code on line 154 in the screenshot not take into account scenarios involving nested subqueries?** 

**When there are two subqueries with the same name in the set_expression, the column lineage is also incorrect.** ```sql insert into public.tgt_tbl1 ( id ) select sq.id from ( select...

Thank you very much, boss. ✅

1. 能举个例子么 2. 再说一下你的预期或者建议