They need the ability to specify aliases for the fields returned from the datasets created from a Stored Procedure when joining multiple Stored Procedures as shown in the snap.
They recommend storing the alias as a separate metadata field in the metadata table (i.e., DisplayName).
This metadata field (Alias) should be updated from the query designer as shown in below snap and while double clicking on a field in the query designer, we should be able to assign an alias to a field.