It looks like the "SQL" and "Query builder" tabs in Metric > Query settings both combine together, as opposed to just using the contents of one or the other. Is that expected behavior? (It's not what I would've expected? But maybe that unlocks add'l functionality, not sure)
In other words, if I set up a query using the sql tab, and then decide to switch to query builder, or vice versa, and I don't clear the contents of the originally-used tab, the metric will break.
Here's a screen recording of the behavior. If this is a bug, I'll go ahead and raise a github issue