hi chapo dev here. the tl;dr is diesel. that’s the biggest reason to switch to node. we actually spent the most time discussing which ORM/QB to use lol.

building and testing the queries will be so much easier, then we can implement the query in diesel up in lemmy via the sql escape hatch and a struct to handle the return value if diesel doesn’t offer what we need. off the top of my head, diesel doesn’t support recursive CTEs, self joins, joins for updates/deletes, no having, group by was just added.