Pete,
There is of course a hidden agenda here: I'd like to be able to connect to external databases and having "internal" SQL would be one step to that direction.
(Whoops, it's no longer hidden!)
Why? Well, take the new Plant Database. As I've reported, the Plant tool does not use the database but text files generated by the database. If the database is updated, one has to also remember to regenerate the text files - which can only be done from VW & the Plant tool. Not going to happen in real world.
Otherwise I don't care what syntax is used as long as can be used & works - and is a bit "hidden" from Joe. The current syntax is, I think, even more cryptic than SQL.