As I said RStudio is just an IDE, for illustration purposes, think of it as a glorified text editor, the SQL code doesn't get executed on RStudio, the sql command is sent to the server, executed there and data retrieved into R, so there are no limitations imposed by the use of RStudio beyond rare driver incompatibility issues.
Since you are sending SQL commands from R code, the only syntax concern would be scaping quotes when a quoted string is needed in your sql code.