exportToAres fails with DatabaseConnector 7.2.0 because cdm_source columns are returned in lowercase

[ValeUMC]

Environment:

• Achilles 1.7.2 (tried also with Achilles 1.8 from GitHub)
• DatabaseConnector 7.2.0
• SqlRender 1.19.5
• PostgreSQL

Issue:
exportToAres() fails with: Error in dir.create(sourceOutputPath, showWarnings = F, recursive = T) : invalid 'path' argument

Debugging showed that exportToAres() executes:

metadata <- DatabaseConnector::querySql(conn, sql)
sourceKey <- gsub( " ",  "_", metadata$CDM_SOURCE_ABBREVIATION)

When using DatabaseConnector 7.2.0,querySql()returns:

names(metadata)
[1] "cdm_source_name"
    "cdm_source_abbreviation"
    ...
    "cdm_release_date"

Therefore:

metadata$CDM_SOURCE_ABBREVIATION
# NULL

which results in sourceKey = character(0) and sourceOutputPath = character(0).

Downgrading DatabaseConnector to 6.4.0 resolved the issue.