I actually disagree, given that this is a dplyr port. dplyr has always had this feature, and I agree that it can make things difficult, but it can also provide a really, really useful abstraction over your SQL, especially if you need to change databases for whatever reason.
In general, this actually looks like the best dplyr port I've seen, and may actually get me to do some exploratory analysis in Python.