BUG - muliple joins fail in MS Access - expecting additional parenthesis ?

[ovancantfort]

Hello,

I noticed multiple successive joins fail in MS Access.
For example, using the industrial emission DB available at https://sdi.eea.europa.eu/data/ff47e25d-5d4c-491d-b9ce-de17ca61fe6d

library(DBI)
library(odbc)
library(tidyverse)
library(dbplyr)

odbcListDataSources()
con <- dbConnect(odbc::odbc(), 
                 DSN="EPRTR")

sites <- tbl(con, "1_ProductionSite") %>% 
  select(Site_INSPIRE_ID) 
  

facilities <- tbl(con, "2_ProductionFacility") %>% 
  select(Parent_Site_INSPIRE_ID, Facility_INSPIRE_ID )

installations <- tbl(con, "3_ProductionInstallation") %>%
  select(Parent_Facility_INSPIRE_ID, Installation_INSPIRE_ID) 

join <- facilities %>%
  left_join(y= installations, by=c("Facility_INSPIRE_ID"="Parent_Facility_INSPIRE_ID") )%>% 
  left_join(y=sites, by=c("Parent_Site_INSPIRE_ID"="Site_INSPIRE_ID") )

 join %>% show_query()

We get the query

SELECT
  `Parent_Site_INSPIRE_ID`,
  `Facility_INSPIRE_ID`,
  `Installation_INSPIRE_ID`
FROM `2_ProductionFacility`
LEFT JOIN `3_ProductionInstallation`
  ON (`2_ProductionFacility`.`Facility_INSPIRE_ID` = `3_ProductionInstallation`.`Parent_Facility_INSPIRE_ID`)
LEFT JOIN `1_ProductionSite`
  ON (`2_ProductionFacility`.`Parent_Site_INSPIRE_ID` = `1_ProductionSite`.`Site_INSPIRE_ID`)

This query fails in Access with the message:

Syntax error (missing operator) in query expression '(`2_ProductionFacility`.`Facility_INSPIRE_ID` =
  `3_ProductionInstallation`.`Parent_Facility_INSPIRE_ID`)

However, similar queries generated by Access have parenthesis around the first join. Adding parenthesis to the query generated by dplyr and copy/paste to Access allows the query to run successfully.

SELECT
  `Parent_Site_INSPIRE_ID`,
  `Facility_INSPIRE_ID`,
  `Installation_INSPIRE_ID`
FROM (
`2_ProductionFacility`
LEFT JOIN `3_ProductionInstallation`
  ON (`2_ProductionFacility`.`Facility_INSPIRE_ID` = `3_ProductionInstallation`.`Parent_Facility_INSPIRE_ID`)
)
LEFT JOIN `1_ProductionSite`
  ON (`2_ProductionFacility`.`Parent_Site_INSPIRE_ID` = `1_ProductionSite`.`Site_INSPIRE_ID`)

dbplyr version 2.5.0
dplyr version 1.1.4