sqlm: SQL-Backed Linear Regression

Fits linear regression models on datasets residing in SQL databases without pulling data into R memory. Computes sufficient statistics inside the database engine via a single aggregation query and solves the normal equations in R.

Version: 0.1.0
Depends: R (≥ 4.1.0)
Imports: dplyr, dbplyr, DBI, glue, purrr, S7, MASS, broom, tibble, stats, utils
Suggests: testthat (≥ 3.0.0), duckdb, orbital, withr, knitr, rmarkdown, quarto
Published: 2026-02-04
DOI: 10.32614/CRAN.package.sqlm (may not be active yet)
Author: Alejandro Hagan [aut, cre]
Maintainer: Alejandro Hagan <alejandro.hagan at outlook.com>
License: MIT + file LICENSE
NeedsCompilation: no
Citation: sqlm citation info
Materials: README, NEWS
CRAN checks: sqlm results

Documentation:

Reference manual: sqlm.html , sqlm.pdf

Downloads:

Package source: sqlm_0.1.0.tar.gz
Windows binaries: r-devel: sqlm_0.1.0.zip, r-release: not available, r-oldrel: not available
macOS binaries: r-release (arm64): not available, r-oldrel (arm64): not available, r-release (x86_64): sqlm_0.1.0.tgz, r-oldrel (x86_64): sqlm_0.1.0.tgz

Linking:

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