Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. I may not have gone where I intended to go, but I think I have ended up where I needed to be.