Functions in WITH clause really are a blessing. Oracle DB supported these for a decade now and that was a gamechanger for me.

https://oracle-base.com/articles/12c/with-clause-enhancement...