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.

In the SQL 101 course, you’ll learn important fundamentals you need to start writing meaningful queries using the language.