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.

Examples

library(dbplyr)
#> 
#> Attaching package: ‘dbplyr’
#> The following objects are masked from ‘package:dplyr’:
#> 
#>     ident, sql, sql_escape_ident, sql_escape_string

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