I'm deeply glad MS is contributing not controlling, given the declining state of MSSQL. Maybe it'll motivate them to pull their socks up over their own flagship product.
There's plenty more low grade shit in what was once a goof product.
I haven't used the features you discuss but then I need basic functionality to work. I've run into stupid performance bugs with trivial CTEs, and I found a link showing a CTE error which I could duplicate (pgres got it right, mssql didn't). Can't find link, sorry.