How does the where clause of R's DBI::dbGetQuery treat a string as a column name?

edit

The where clause of R's DBI::dbGetQuery function treats a string as a column name by concatenating the string with the WHERE clause of the SQL query. For example, if we have a variable column_name that contains the name of a column, we can use it in the WHERE clause of a query as follows:

column_name <- "age"
query <- paste0("SELECT * FROM my_table WHERE ", column_name, " > 30")

This will generate a SQL query that selects all rows from my_table where the column named age has a value greater than 30. When we pass this query to DBI::dbGetQuery, it will be executed on the database and return the results.