Package: sqlscore 0.1.4

William Brannon

sqlscore: Utilities for Generating SQL Queries from Model Objects

Provides utilities for generating SQL queries (particularly CREATE TABLE statements) from R model objects. The most important use case is generating SQL to score a generalized linear model or related model represented as an R object, in which case the package handles parsing formula operators and including the model's response function.

Authors:William Brannon [aut, cre]

sqlscore_0.1.4.tar.gz
sqlscore_0.1.4.zip(r-4.7)sqlscore_0.1.4.zip(r-4.6)sqlscore_0.1.4.zip(r-4.5)
sqlscore_0.1.4.tgz(r-4.6-any)sqlscore_0.1.4.tgz(r-4.5-any)
sqlscore_0.1.4.tar.gz(r-4.7-any)sqlscore_0.1.4.tar.gz(r-4.6-any)
sqlscore_0.1.4.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
sqlscore/json (API)
NEWS

# Install 'sqlscore' in R:

install.packages('sqlscore', repos = c('https://wwbrannon.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/wwbrannon/sqlscore/issues

On CRAN:

glm sql

3.85 score 14 stars 8 scripts 146 downloads 4 exports 23 dependencies

Last updated from:9d0093f2cb. Checks:9 OK. Indexed: yes.

Target	Result	Time
linux-devel-x86_64	OK	129
source / vignettes	OK	233
linux-release-x86_64	OK	170
macos-release-arm64	OK	160
macos-oldrel-arm64	OK	142
windows-devel	OK	83
windows-release	OK	83
windows-oldrel	OK	78
wasm-release	OK	121

Exports:create_statement linpred score_expression select_statement

Dependencies:blob cli cpp11 DBI dbplyr dplyr generics glue lifecycle magrittr pillar pkgconfig purrr R6 rlang stringi stringr tibble tidyr tidyselect utf8 vctrs withr

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Generate a CREATE TABLE statement from a model	create_statement
Unevaluated prediction expressions for models	linpred
Unevaluated prediction expressions for models	score_expression
Generate a SELECT statement from a model	select_statement
sqlscore: Utilities to score GLMs and related models in SQL.	sqlscore-package sqlscore