tidypredict_sql

Arguments
Examples

Returns a SQL query with formula to calculate fitted values

tidypredict_sql(model, con)

Arguments

model	An R model or a tibble 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:tidypredict�:
#> 
#>     ident, sql
#> The following objects are masked from �package:dplyr�:
#> 
#>     ident, sql

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