Impersonate a specific role

is it possible to take a given roles name and then create a ghost user with its powers just to run a query. I dont want to run as some user, just execute cloud queries and abiding by the ACLs in place