Something I've found useful is the sqldf package [0], which lets you use data frames as tables in SQL with all the power of joins and so on.
Instead, learn a native R package like dplyr or data.table that supports all the power of SQL, and is v. v. fast.