Kusto Workbench is built for the tight loop of writing queries, running them, inspecting results, and iterating quickly; without forcing you to abandon existing .kql / .csl files. It uses the official ...
Pivot tables still have their place, but I'd rather type one formula for a quick summary.