能否更新下prompt，让生成的SQL支持UNION ALL。

我使用kimi、通义灵码（其他没测试）问下面这个问题（为了脱敏，我将表名和字段名均隐藏）

能否生成一个SQL，查询G表，右加入W表，G.id = W.gid，
查询表为：G.type,
G.id AS gid,
W.a AS a,
W.b,
W.c,
W.d,
W.e，同时判断当G.type != 'UNIONType'正常返回，G.type = 'UNIONType'
将G.id聚合同时按照
SUM(W.c) AS c,
MIN(W.d) AS d,
MIN(W.e) AS e将这三项返回

之后通义灵码返回的代码

SELECT 
    CASE 
        WHEN G.type != 'UNIONType' THEN G.type 
        ELSE NULL 
    END AS type,
    CASE 
        WHEN G.type != 'UNIONType' THEN G.id 
        ELSE NULL 
    END AS gid,
    CASE 
        WHEN G.type != 'UNIONType' THEN W.a 
        ELSE NULL 
    END AS a,
    CASE 
        WHEN G.type != 'UNIONType' THEN W.b 
        ELSE NULL 
    END AS b,
    CASE 
        WHEN G.type != 'UNIONType' THEN W.c 
        ELSE NULL 
    END AS c,
    CASE 
        WHEN G.type != 'UNIONType' THEN W.d 
        ELSE NULL 
    END AS d,
    CASE 
        WHEN G.type != 'UNIONType' THEN W.e 
        ELSE NULL 
    END AS e,
    CASE 
        WHEN G.type = 'UNIONType' THEN G.id 
        ELSE NULL 
    END AS union_gid,
    SUM(CASE WHEN G.type = 'UNIONType' THEN W.c ELSE 0 END) AS union_c,
    MIN(CASE WHEN G.type = 'UNIONType' THEN W.d END) AS union_d,
    MIN(CASE WHEN G.type = 'UNIONType' THEN W.e END) AS union_e
FROM 
    G
RIGHT JOIN 
    W ON G.id = W.gid
GROUP BY 
    G.id, G.type, W.a, W.b, W.c, W.d, W.e
HAVING 
    G.type != 'UNIONType' OR union_gid IS NOT NULL;

然后调用结果......

kimi也一样，生成的格式差不多

但是我用了我同事自己训练的模型给的SQL

SELECT 
***
FROM G
RIGHT JOIN   W ON G.id = W.gid
WHERE G.type != 'UNIONType'

UNION ALL
SELECT ***

看到了吗，用UNION ALL将复杂查询直接简化成2个SQL，不仅易读而且