You can create a mapping table of Olson time zones to Windows time zones, and then use a function to convert.

For example

CREATE TABLE TzToWindows(Olson varchar(300) PRIMARY KEY, Windows varchar(50) NOT NULL);

Then create an inline Table Valued Function to query it

CREATE FUNCTION dbo.AtOlsonTimeZone (@value datetimeoffset, @olson varchar(300))
RETURNS TABLE
AS RETURN
SELECT @value AT TIME ZONE tz.Windows AS value
FROM TzToWindows tz
WHERE tz.Olson = @olson;

You can then do a simple SELECT , or you can CROSS APPLY it from another table.

SELECT *
FROM dbo.AtOlsonTimeZone(SYSDATETIME(), 'Pacific/Fakaofo');

This fiddle has data that has been pulled from the official Unicode Github repo .