Slow Performance on giant derived table

This has been an ongoing issue. In SSMS, imagine you have

Select
From (40,000 lines of Select UNION ALL query) as t
Inner Join

After you hit space, it basically freezes SSMS until it parses the entire thing. I just wanted to throw it out there. Basically derived tables aren't allowed to be very complex so parsing to the first UNION ALL would give you all the columns you need. This info might lead to other parsing enhancements.

Unless that first SELECT from which the derived table is derived is complex itself :)

Well you know that the SQL in the editor is a bunch of derived tables. SQL Assistant doesn't know that, it needs to parse the entire thing to find out where each statement starts and ends, including the main query.

Also, if syntax checking is enabled it may take a long time too, just to send the code to the database, have it check it, and het and parse results.

Honestly I'm not sure the issue can be resolved easily. I'm thinking it might be easier to optimize the 40k lines long SQL statements and cut it down to a few lines of code, converting the repeating sub queries to table data and pulling that with a join, or using dynamic SQL within a loop.