How I do it is by typing SQL in to the editor, and when I am happy with the logic using the "EXPLAIN PLAN" feature to translate the SQL into Druid concepts: