You may change the properties of each object added to the query by right clicking the object and selecting the Edit... item from the drop-down menu or simply by double-clicking the object header.

The Datasource Properties dialog may vary from server to server, but at least the Alias property is the same for all database servers.