I found Nimantha's answer to be good, but slightly confusing to read, so I formulated an alternative (works in Looker Studio).

Assuming that <FIELD> is a DATETIME and has timezone of UTC and I want to convert it to EST:

DATETIME_ADD(<FIELD>, INTERVAL (DATETIME_DIFF(CURRENT_DATETIME("EST"), CURRENT_DATETIME("UTC"), HOUR)) HOUR)