Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

FR: Allow lowercase column names #1578

Open
eutwt opened this issue Feb 4, 2025 · 0 comments
Open

FR: Allow lowercase column names #1578

eutwt opened this issue Feb 4, 2025 · 0 comments

Comments

@eutwt
Copy link

eutwt commented Feb 4, 2025

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant