I write my SQL in Visual Studio, which has not merely syntax highlighting but Intellisense and type checking. Because I'm generally writing LINQ. You can use LINQPad to write ad-hoc queries and ...

Does 3.23 support derived tables (aka inline views)? If so, plug the SELECT statement that would have generated the temp. table directly into your main query, and Bob's your uncle.