You can combine/concatenate SQLTag values in FactoryPMI. That’s what the “Expression/SQL” section is for.
To address that custom alerting message:
You can accomplish that in FactorySQL. With an OPC/Action item in a group, enable alerting. Choose “Custom Message”, type your message, and right click (or cntl+space) to “add item reference”, this can insert the value of any items from your group.
The next trick is getting a SQLTag value in your group. You could always drag the OPC item in directly. Alternatively, you could have an Action Item that queries the database (this is nasty).
It’s not 100% straightforward because the alert condition is based on a SQLTag value, but the message is another SQLTag (or equivalently, a SQLTag expression). I entered this as a feature request. Feel free to add/reply to it.