Constrained language mode is not a security feature. The constraint is to match the capabilities that were in Windows S (ARM). It was designed for application developers to test their scripts on x86-64 from r compatibility with Windows S on ARM. Using it as a security feature, you are just hoping some vulnerability affects only the portable portion of the language, but there is no basis for this. Mostly you just make people suffer for no benefit. Windows S doesn't exist anymore and Windows 11 on ARM doesn't use constrained language mode (afaik, will test tomorrow).
Oh, also it's easy for someone to bypass it because it's not a security boundary.
Which types of command-related attacks could be prevented by CLM and which cannot?

