Support for Subqueries and OVER clauses

[camult]

I was trying to use the function show_dplyr but I got the following error message:

Error: Subqueries are not supported Error: OVER clauses are not supported Error: Joins of three or more tables are unsupported

Is there a any plans to update it in the near future to add these support?

Thank you

[ianmcook]

Hi @camult, yes I intend to add support for those types of queries, first in the dependency package queryparser and then in tidyquery. I don't have a time estimate for this yet. In the meantime, if you want to use SQL to run queries on R data frames, sqldf is another option; it supports a wider variety of queries at present.