all_of works just fine too. back ticks does result in shorter code though...
> dat <- data.frame("foo bar" = 1:5, x = letters[1:5])
> names(dat)[1] <- "foo bar"
> select(dat, all_of("foo bar"))
foo bar
1 1
2 2
3 3
4 4
5 5
> select(dat, `foo bar`)
foo bar
1 1
2 2
3 3
4 4
5 5
all_of has the advantage that you can pass string vectors in though, so there are places to use it...