While checking SQL syntax itself is somewhat straightforward, [Joe]’s sql-lint tool will also check the semantics of it by looking up the actual database and performing sanity checks on it.

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.