sqlalchemy中，如何合并相同列的数据为一列

Question

比如，查询得出来的结果是

[("a","b","c"),
("a","b","d"),
("a","b","e"),("aa","bb","cc"),("aa","bb","dd")]

怎么将结果合并成`

[("a","b","c,d,e"),("aa","bb","cc,dd")]

想这类问题是不是只能在python层面上进行过滤？orm层上能直接过滤么？

Answer 1

你看看query对象是不是有个distinct方法