We found a way to organize large SQL decomposing them in smaller chunks and organize those chunks like in a "jupiter notebook" so you also see results for intermediate results, an example:

https://ui.tinybird.co/snapshot/7437e5efa1f944a0b7cc01775169...