[Strs2FillMyDrms]

I've been encountering a lot of issues, when doing dedicated queries, specially when a team is small, I've found is sometimes more useful to just do the grouping or left join (if more than 2 are required) manually.

The problem is ofc scalability, if your team is small it is better to just have some few, but very specific queries, and do whatever transactions required on a layer above.

It may be the difference between correcting a few lines, vs reworking 20+ different queries, and testing each one individually.