e.g., under the shipping tab, user selects a known shipping address. I want to use SuiteQL or some other method of returning the highlighted label

I think you need the Label column from the EntityAddressbook table.