Function reference

All functions and classes exported by sqlm.

Model fitting

Function	Description
lm_sql()	Fit a linear regression model using SQL aggregation

Classes

Class	Description
lm_sql_result	S7 result object for SQL-backed linear models

---

lm_sql()

SQL-Backed Linear Regression

Usage

lm_sql(formula, data, tol = 1e-07)

Arguments

Argument	Description
formula	A formula object (e.g., price ~ x + cut).
data	A tbl_sql object (from dbplyr).
tol	Tolerance for detecting linear dependency.

Value

An S7 object of class lm_sql_result, or a tibble with a model list-column if the data is grouped.

Description

Fits a linear regression model using SQL aggregation. Supports numeric and categorical predictors, interaction terms, dot expansion, transforms (I(), log(), sqrt()), grouped data, and automatic NA handling.

---

lm_sql_result

Result object for SQL-backed Linear Model

Usage

lm_sql_result(
  coefficients = integer(0),
  std_error = integer(0),
  sigma = numeric(0),
  r_squared = numeric(0),
  adj_r_squared = numeric(0),
  f_statistic = integer(0),
  f_p_value = integer(0),
  logLik = numeric(0),
  AIC = numeric(0),
  BIC = numeric(0),
  nobs = numeric(0),
  df_residual = numeric(0),
  df_model = numeric(0),
  statistic = integer(0),
  p_value = integer(0),
  call = NULL
)

Description

An S7 class that holds all results from a SQL-backed linear model fit. Compatible with broom::tidy() and broom::glance().