dplyr comes to duckdb

Writing SQL with familiar verbs.
R
duckdb
dplyr
Author

novica

Published

2026-01-29

Of course, we have all used duckplyr by now. But now we can use dplys syntax in duckdb thanks to an extension: dplyr.

I would guess that the inspiration for this comes from the 2023 Google paper pipe syntax in SQL. Since then at least, as far as I know, Databricks adopted it in 2025: SQL Gets Easier: Announcing New Pipe Syntax.

Screenshot from the Google paper

And now piping is avaiable in duckdb. Fun! But wait…

Crying duck from tenor gifs

If you want to try it out and like me install the latest duckdb (v1.4.4 (Andium) 6ddac802ff), the extension will not be avaiable:

INSTALL dplyr FROM community;
HTTP Error:
Failed to download extension "dplyr" at URL "http://community-extensions.duckdb.org/v1.4.4/windows_amd64/dplyr.duckdb_extension.gz" (HTTP 404)

Hopefull the maintainer will fix this soon.