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.

You can use RSPT to reduce network traffic and to shift CPU load by sending queries for remote data to a remote server. (If the server is a SAS/CONNECT single-user server you can also RSUBMIT queries ...