Add easy column aliasing for Select-Object
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.
