A Linear Model to 'SQL' Compiler

This is a cross-platform linear model to 'SQL' compiler. It generates 'SQL' from linear and generalized linear models. Its interface consists of a single function, modelc(), which takes the output of lm() or glm() functions (or any object which has the same signature) and outputs a 'SQL' character vector representing the predictions on the scale of the response variable as described in Dunn & Smith (2018) and originating in Nelder & Wedderburn (1972) . The resultant 'SQL' can be included in a 'SELECT' statement and returns output similar to that of the glm.predict() or lm.predict() predictions, assuming numeric types are represented in the database using sufficient precision. Currently log and identity link functions are supported.


News

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("modelc")

1.0.0.0 by Hugo Saavedra, 4 months ago


https://github.com/sparkfish/modelc


Report a bug at https://github.com/sparkfish/modelc/issues


Browse source code at https://github.com/cran/modelc


Authors: Sparkfish Analytics [cph] , Hugo Saavedra [aut, cre]


Documentation:   PDF Manual  


MIT + file LICENSE license


Suggests testthat


See at CRAN