Created a new using R to connect to SQL section and moved the existing running SQL queries in R section into it. Added a short intro section on dplyr and then added the error and associated fix for the DBI varchar(max) bug.
Why are these changes being made?
The SQL in R section was a bit light on some useful topics now that more people are using R in this way. The DBI bug is quite a common one so needed referencing, but also didn't look like we'd really given much attention to dbplyr in the existing guidance.
Checklist before requesting a review
[ ] I have checked the contributing guidelines
[ ] I have checked for and linked any relevant issues that this may resolve
[ ] I have checked that these changes build locally
[ ] I understand that if merged into main, these changes will be publicly available
Overview of changes
Created a new using R to connect to SQL section and moved the existing running SQL queries in R section into it. Added a short intro section on dplyr and then added the error and associated fix for the DBI varchar(max) bug.
Why are these changes being made?
The SQL in R section was a bit light on some useful topics now that more people are using R in this way. The DBI bug is quite a common one so needed referencing, but also didn't look like we'd really given much attention to dbplyr in the existing guidance.
Checklist before requesting a review