Show SQL equivalent code of dplyr code in R

Question

How to see MYSQL equivalent code of dplyr code?

Answer 1

show_query() translated dplyr code into sql equivalent code.

Ex:

> ofc1 = tbl(db,"offices") %>% select("officeCode")
> ofc1 %>% show_query()
<SQL>
SELECT `officeCode`
FROM `offices`