An alternative - again, if supported - would be to create a view that works the same as the derived table, and use this in your query instead.

Microsoft Copilot can write basic SQL code for your employees. Read about our tests that prove this is true.