Great writeup by the Kuzu team!
An especially interesting area to us is how to redo these to be accelerated with GPUs. Ex: See https://www.adms-conf.org/2014/adms14_wu.pdf
We've been taking a worse-is-better approach to use these kinds of ideas that seems worth writing up at some point. Super fun time for rethinking these :)