There is research as of last year which brings unoptimised impls of those join algorithms to “on-par” with optimized non-optimal industry impls.

There’s still research to be done in optimizing these algorithms in both theory and practice.