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