The short story here is that this doesn’t work for SQL data, only for timeseries data (Prometheus, Influx, …).
I struggled through this a fair bit and recorded my findings in this thread/post that would hopefully be helpful: Using SQL data to label time series (via v7 transformations?) - #3 by svetb
In summary, this should be implemented at some point, but is dependent on a still-open GitHub issue.