[chrisjc]

In other words, it creates a "push-down" to SQLite?

So that we can appreciate your point about the elegance of the API, how would you do the opposite to allow execution to take place on the data-frame?

[phillc73]

There's an R package for that! Well, multiple really. The `sqldf`[1] package has been around for a while, there's `tidyquery`[2] and also one I wrote called `duckdf`[3]. All three support writing SQL queries to directly access dataframes.

[1] https://github.com/ggrothendieck/sqldf

[2] https://github.com/ianmcook/tidyquery

[3] https://github.com/phillc73/duckdf

[chrisjc]

Not exactly what I was asking, but still some pretty awesome links/projects. Thanks for the links.

I'm pretty sure that I'll be getting my hands dirty with R eventually.