We’re stoked to announce that dbplyr 1.3.0 is now available on CRAN. dbplyr is the database backend for dplyr, translating dplyr syntax into SQL. This is a minor release primarily for compatibility with dplyr 0.8.0. However, there have been some changes to the API, and minor improvements (the full details of which can be found in the changelog). A more substantive update can be expected after rstudio::conf.
Calls of the form
dplyr::foo()are now evaluated in the database, rather than locally.
tbl_sql()has been formally deprecated.
tblobjects now include a class generated from the class of the underlying connection object. This makes it possible for dplyr backends to implement different behaviour at the dplyr level, when needed.
as.integer64(x)is translated to
CAST(x AS BIGINT).
cummean()now translates to SQL
AVG()as opposed to
x %in% yis now translated to
Thank you to the 49 people who contributed to this release: @AkhilGNair, @andypohl, @batpigandme, @bogdanrau, @cboettig, @cderv, @chris-park, @colearendt, @copernican, @cseidman, @DavisVaughan, @dgrtwo, @dlindelof, @dpprdan, @edgararuiz, @foonwong, @gbisschoff, @hadley, @halldc, @happyshows, @iangow, @javierluraschi, @jimhester, @jinaliu, @JohnMount, @jonthegeek, @jrjohnson0821, @karldw, @kevinykuo, @kmace, @krlmlr, @lincis, @lionel-, @mfalcioni1, @mgirlich, @mkirzon, @mkuehn10, @mtmorgan, @N1h1l1sT, @Prometheus77, @ramnathv, @romainfrancois, @sandan, @sverchkov, @tdsmith, @tmastny, @TomWeishaar, @vitallish, and @yutannihilation.