You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I very often get an error because I try tbl |> select(column_name) and I should have written tbl |> select(COLUMN_NAME) because the database schema shows the columns in upper case, and R brings that in as-is. Typing column names without matching the specific case is a hard habit to shake for someone used to writing SQL where the case doesn't matter. So, could there be an option (either global, or an argument when creating the table object) to specify the case of the column names? In the generated SQL it won't matter, so it seems a user could just specify "lower" and then dbplyr could bring them in that way, so the user can type all their column names in lower case.
The text was updated successfully, but these errors were encountered:
I very often get an error because I try
tbl |> select(column_name)
and I should have writtentbl |> select(COLUMN_NAME)
because the database schema shows the columns in upper case, and R brings that in as-is. Typing column names without matching the specific case is a hard habit to shake for someone used to writing SQL where the case doesn't matter. So, could there be an option (either global, or an argument when creating the table object) to specify the case of the column names? In the generated SQL it won't matter, so it seems a user could just specify "lower" and then dbplyr could bring them in that way, so the user can type all their column names in lower case.The text was updated successfully, but these errors were encountered: