The main reason is that, when using stored procedures, I write the query in query analyzer, and I get syntax highlighting, and I can just run it right there and see if I have any problems.

You can use VB.NET or C# to write procedural code and create user-defined types and aggregates in SQL Server.

Using JSINQ, however, you can write similar SQL queries while programming in JavaScript. This means you now have a query language in JavaScript that you can use against arrays and DOM node lists.

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.

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.