tidypredict_sql: Returns a SQL query with formula to calculate fitted values
In tidypredict: Run Predictions Inside the Database

View source: R/to_sql.R

tidypredict_sql

R Documentation

Returns a SQL query with formula to calculate fitted values

Description

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())

tidypredict documentation built on Oct. 18, 2026, 5:06 p.m.

tidypredict index

Package overview README.md bagger models bart models Create a regression spec - version 2 Create a tree spec - version 2 Cubist models Database write-back Decision trees, using C5.0 Decision trees, using rpart fda models Float precision at split boundaries Generalized Linear Regression glmnet models Gradient boosting, using H2O How tidypredict generates tree formulas lda models LightGBM models Linear Regression MARS models via the `earth` package mixOmics PLS models Model-based boosting, using mboost multinom models NaiveBayes models nnet models Non-R Models nullmodel models Oblique Random Forest, using aorsf qda models Random Forest Random Forest - partykit Random Forest, using Ranger RuleFit, using xrf Save and re-load models sda models sparsediscrim models Supported models Support vector machines, using kernlab XGBoost models

rdrr.io home R language documentation Run R code online

CRAN packages Bioconductor packages R-Forge packages GitHub packages

Note that we can't provide technical support on individual packages. You should contact the package authors for that.

Tweet to @rdrrHQ

GitHub issue tracker

ian@mutexlabs.com