OUTER APPLY when building reports in the SQL editor

[dman]

This is probably a thing which should be valid but currently is not. The OUTER APPLY when using SQL can be extremely useful especially if you want to manipulate data returned in the reports. Instead of having sub select statements (Which causes more processing time) the OUTER APPLY joins can actually improve performance tenfold. I'm baffled as to why the sql editor things that OUTER APPLY is not a valid SQL syntax especially as we use SQL server? Maybe this can be allowed if the database type is of SQL server?

[ErikT]

@darrenbwilliams The built-in query builder indeed has some limitations. To get the report you are after, I would suggest writing it in SSMS instead.