This limitation had to be lifted for CTEs to be reused, which is in the same labs release as the JSON functions mentioned here. I haven't checked yet if it is

This limitation had to be lifted for CTEs to be reused, which is in the same labs release as the JSON functions mentioned here. I haven't checked yet if it is lifted for CTEs only, or all cases. But CTEs are a replacement for most (all?) uses of temporary tables that I can think of.