Returns a SQL query with formula to calculate fitted values — tidypredict_sql • tidypredict

Returns a SQL query with formula to calculate fitted values

Usage

tidypredict_sql(model, con)

Arguments

model: An R model or a list with a parsed model
con: Database connection object. It is used to select the correct SQL translation syntax.

Value

A SQL query, as returned by dbplyr::translate_sql(). Models that produce one formula per class or per outcome return a list of queries.

Examples

model <- lm(mpg ~ wt + am + cyl, data = mtcars)
tidypredict_sql(model, dbplyr::simulate_dbi())
#> <SQL> ((39.4179334351865 + ("wt" * -3.12514220026708)) + ("am" * 0.176493157719672)) + ("cyl" * -1.5102456624971)