sqldf: Manipulate R Data Frames Using SQL

The sqldf() function is typically passed a single argument which is an SQL select statement where the table names are ordinary R data frame names. sqldf() transparently sets up a database, imports the data frames into that database, performs the SQL select or other statement and returns the result using a heuristic to determine which class to assign to each column of the returned data frame. The sqldf() or read.csv.sql() functions can also be used to read filtered files into R even if the original files are larger than R itself can handle. 'RSQLite', 'RH2', 'RMySQL' and 'RPostgreSQL' backends are supported.

Version:	0.4-12
Depends:	R (≥ 3.1.0), gsubfn (≥ 0.6), proto, RSQLite
Imports:	DBI, chron
Suggests:	RH2, RMySQL, RPostgreSQL, svUnit, tcltk, MASS
Published:	2026-01-30
DOI:	10.32614/CRAN.package.sqldf
Author:	G. Grothendieck [aut, cre]
Maintainer:	G. Grothendieck <ggrothendieck at gmail.com>
BugReports:	https://github.com/ggrothendieck/sqldf/issues
License:	GPL-2
URL:	https://github.com/ggrothendieck/sqldf
NeedsCompilation:	no
Materials:	README, NEWS, INSTALL
In views:	Databases, HighPerformanceComputing
CRAN checks:	sqldf results

Documentation:

Reference manual:

sqldf.html , sqldf.pdf

Downloads:

Package source:	sqldf_0.4-12.tar.gz
Windows binaries:	r-devel: sqldf_0.4-12.zip, r-release: sqldf_0.4-12.zip, r-oldrel: sqldf_0.4-12.zip
macOS binaries:	r-release (arm64): sqldf_0.4-12.tgz, r-oldrel (arm64): sqldf_0.4-12.tgz, r-release (x86_64): sqldf_0.4-12.tgz, r-oldrel (x86_64): sqldf_0.4-12.tgz
Old sources:	sqldf archive

Reverse dependencies:

Reverse depends:	Fgmutils, metevalue, smbinning
Reverse imports:	BETS, casper, Clustering, dMrs, elfgen, epicR, fdq, FIESTA, FIESTAutils, healthyR, icesDatsuQC, kangar00, KinSwingR, miRNAtap, msig, multimorbidity, mygene, nlive, OnomasticDiversity, puzzle, r3Cseq, RareComb, RcextTools, RiboProfiling, RImmPort, RITAN, Rprofet, RSDA, scorecardModelUtils, STRINGdb, tcpl, WeibullFit
Reverse suggests:	DOPE, prqlr, R6causal, rcellminer, remotePARTS

Linking:

Please use the canonical form https://CRAN.R-project.org/package=sqldf to link to this page.