If you don't need recursive CTEs on sharded databases, they'll work today. We're actively using them

Oh, I see, that's unfortunate! Hopefully, we can remedy that though as soon as possible.