dbplyr, a database backend for dplyr, just released v2.0.0 today… Awesome stuff here!
dbplyr 2.0.0 comes loaded with improvements including the translation of dplyr’s new across() function. If you aren’t familiar with this library, dbplyr translates your dplyr syntax to SQL. I regularly connect to enterprise databases using R and have almost completely transitioned from SQL. Yes, SQL is awesome. Yes, using dplyr is a lot more fun!
Source:
* tidyverse blog’s dbplyr 2.0.0 Official Announcement
Text and figures are licensed under Creative Commons Attribution CC BY 4.0. The figures that have been reused from other sources don't fall under this license and can be recognized by a note in their caption: "Figure from ...".
For attribution, please cite this work as
Orraca (2020, Nov. 4). Javier Orraca: What's New in dbplyr 2.0.0. Retrieved from https://www.javierorraca.com/posts/2020-11-04-dbplyr-2.0.0/
BibTeX citation
@misc{orraca2020what's,
author = {Orraca, Javier},
title = {Javier Orraca: What's New in dbplyr 2.0.0},
url = {https://www.javierorraca.com/posts/2020-11-04-dbplyr-2.0.0/},
year = {2020}
}