Nice Article. The last two workarounds can be achieved by a statement as follows. No need of workarounds

SELECT

Country.CountryName AS [name],

...