python 树结构 sqlalchemy_萌新求助 ! Python sqlalchemy 的复杂写法。

大佬们 求助！ 有没有 orm 写的很 6 的大佬！！！

救救萌新！

现有一条原生 sql。

select a.date,sum(a.tag_count) as tag_count,a.tag_id,a.tag_name,b.user_id,b.user_name from (

(

select z.netflow_alias,count(1) as tag_count,z.date,z.product_id,x.tag_id,x.tag_name from

(

SELECT netflow_alias,left(create_time,10) as date,product_id FROM weidian_operator.t_tj_order_detail_qingshe

where left(create_time,10)=DATE_SUB(curdate(),INTERVAL 1 DAY)

) z

left join

(

select q.tag_id,q.product_id,w.tag_name from

(SELECT tag_id,product_id FROM weidian_operator.t_product_tag ) q

left join

(select id,tag_name from weidian_operator.t_tag) w

on q.tag_id=w.id

) x

on z.product_id=x.product_id

group by x.tag_id

) a

left join

(select netflow_alias,user_name,user_id from weidian_operator.t_tj_team_relation where user_id is not null) b

on a.netflow_alias=b.netflow_alias

)

where user_id is not null

group by a.date,b.user_id;

那么请问 orm 怎么写。 哪位大佬肯帮帮我。呜呜呜