Renaming columns in a MySQL select statement with R package RJDBC
select a as b
from table

drv <- JDBC("com.mysql.jdbc.Driver", "C:/JDBC/mysql-connector-java-5.1.18-bin.jar", identifier.quote="`")
conn <- dbConnect(drv, "jdbc:mysql://server/schema?useOldAliasMetadataBehavior=true", "username", "password")
query <- "SELECT `a` AS `b` FROM table"
result <- dbGetQuery(conn, query)
dbDisconnect(conn)

CREATE OR REPLACE VIEW v_table AS
SELECT a AS b
FROM table

SELECT b FROM v_table