In SQL, columns can be aliased as simply as this

Select GivenName as FirstName, Surname as "Last Name"

With PowerShell, I generally refer to a webpage or reference guide for a refresher on the syntax for Select-Object aliasing.

Select-Object @{Name="Surname";Expression={$."Last Name"}}, @{Name="GivenName";Expression={$."First Name"}}

I understand that Expressions are Powerful, but SQL supports similar power as seen in this example

Select GivenName AS FirstName, Surname AS 'Last Name' FROM names

SELECT NameChange =
CASE
WHEN Surname = 'LeMaire' THEN 'The Mayor'
END
FROM names

Please add easier column name aliasing for Select-Object.