New features in MySQL 9.0.0 This initial 9.x Innovation release, Oracle says, is preparation for new features in upcoming releases. But it still contains useful things and can be upgraded to from ...

Yeah, I wouldn't expect MySQL to support this optimization either. Also, views often perform worse than if you put the view's query inline in the query using the view, which is baffling.