{ "_id": "6aab9cfa3d719c1f8406c6d2", "Package": "sqlscore", "Authors@R": "c(person(\"William\", \"Brannon\", email=\"wwbrannon@email.wm.edu\", role=c(\"aut\", \"cre\")))", "Version": "0.1.4", "Title": "Utilities for Generating SQL Queries from Model Objects", "Description": "Provides utilities for generating SQL queries\n(particularly CREATE TABLE statements) from R model objects.\nThe most important use case is generating SQL to score a\ngeneralized linear model or related model represented as an R\nobject, in which case the package handles parsing formula\noperators and including the model's response function.", "License": "MIT + file LICENSE", "URL": "https://github.com/wwbrannon/sqlscore/", "BugReports": "https://github.com/wwbrannon/sqlscore/issues", "RoxygenNote": "6.1.1", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://wwbrannon.r-universe.dev", "Date/Publication": "2019-03-17 16:48:33 UTC", "RemoteUrl": "https://github.com/wwbrannon/sqlscore", "RemoteRef": "HEAD", "RemoteSha": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "NeedsCompilation": "no", "Packaged": { "Date": "2026-09-17 07:49:07 UTC", "User": "root" }, "Author": "William Brannon [aut, cre]", "Maintainer": "William Brannon ", "_user": "wwbrannon", "_type": "src", "_file": "sqlscore_0.1.4.tar.gz", "_fileid": "https://r2.ropensci.org/1b5a0f2c4dd97fb6dc07fcd376f94c17145de3304dc67656b188f15f8085d1ea", "_filesize": 118959, "_sha256": "1b5a0f2c4dd97fb6dc07fcd376f94c17145de3304dc67656b188f15f8085d1ea", "_expires": "2026-12-26T07:55:36.000Z", "_created": "2026-09-17T07:49:07.000Z", "_published": "2026-09-17T07:55:38.788Z", "_jobs": [ { "job": 105120763603, "time": 132, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10485664702" }, { "job": 105120763604, "time": 149, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10486165948" }, { "job": 105120763657, "time": 142, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "10485739958" }, { "job": 105120763791, "time": 137, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "10485814268" }, { "job": 105119866496, "time": 197, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "10486105823" }, { "job": 105120763560, "time": 117, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "10486062434" }, { "job": 105120763650, "time": 79, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10486215717" }, { "job": 105120763745, "time": 105, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "10486220717" }, { "job": 105120763629, "time": 69, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10486047736" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/35196151149", "_status": "success", "_upstream": "https://github.com/wwbrannon/sqlscore", "_commit": { "id": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "author": "William Brannon ", "committer": "William Brannon ", "message": "update LICENSE year\n", "time": 1552841313 }, "_maintainer": { "name": "William Brannon", "email": "wwbrannon@email.wm.edu" }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.3.0", "role": "Depends" }, { "package": "dbplyr", "version": ">= 1.0.0", "role": "Imports" }, { "package": "testthat", "role": "Suggests" }, { "package": "arm", "role": "Suggests" }, { "package": "glmnet", "role": "Suggests" }, { "package": "mboost", "role": "Suggests" }, { "package": "covr", "role": "Suggests" } ], "_owner": "wwbrannon", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_topics": [ "glm", "sql" ], "_stars": 14, "_contributors": [ { "user": "wwbrannon", "count": 188, "uuid": 1487314 } ], "_userbio": { "uuid": 1487314, "type": "user", "name": "William Brannon", "followers": 31 }, "_downloads": { "count": 55, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlscore" }, "_devurl": "https://github.com/wwbrannon/sqlscore", "_searchresults": 11, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/sqlscore.html", "LICENSE" ], "_cranurl": false, "_releases": [ { "version": "0.1.0", "date": "2016-12-11" }, { "version": "0.1.1", "date": "2017-01-07" }, { "version": "0.1.2", "date": "2017-06-26" }, { "version": "0.1.3", "date": "2018-04-29" }, { "version": "0.1.4", "date": "2019-03-17" } ], "_exports": [ "create_statement", "linpred", "score_expression", "select_statement" ], "_help": [ { "page": "create_statement", "title": "Generate a CREATE TABLE statement from a model", "topics": [ "create_statement" ] }, { "page": "linpred", "title": "Unevaluated prediction expressions for models", "topics": [ "linpred" ] }, { "page": "score_expression", "title": "Unevaluated prediction expressions for models", "topics": [ "score_expression" ] }, { "page": "select_statement", "title": "Generate a SELECT statement from a model", "topics": [ "select_statement" ] }, { "page": "sqlscore", "title": "sqlscore: Utilities to score GLMs and related models in SQL.", "topics": [ "sqlscore-package", "sqlscore" ] } ], "_readme": "https://github.com/wwbrannon/sqlscore/raw/HEAD/README.md", "_rundeps": [ "blob", "cli", "cpp11", "DBI", "dbplyr", "dplyr", "generics", "glue", "lifecycle", "magrittr", "pillar", "pkgconfig", "purrr", "R6", "rlang", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "utf8", "vctrs", "withr" ], "_score": 2.886490725172482, "_indexed": true, "_nocasepkg": "sqlscore", "_universes": [ "wwbrannon" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.4", "date": "2026-09-17T07:51:23.000Z", "distro": "resolute", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/80256a874d6c70515e49d43ef37b147f4ae90c651960818ae9f48df07fbaed54", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/35196151149" }, { "r": "4.6.1", "os": "linux", "version": "0.1.4", "date": "2026-09-17T07:51:40.000Z", "distro": "resolute", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/8fbd29c450ea7e940eed43c98cb7a5895a50878aa97ae83db7677cf20021c8c6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/35196151149" }, { "r": "4.5.3", "os": "mac", "version": "0.1.4", "date": "2026-09-17T07:54:39.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/77eb4932b24ef0eb3d77a565778dac61c8f7469c77ed35b882e33aa0d7676d8f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/35196151149" }, { "r": "4.6.1", "os": "mac", "version": "0.1.4", "date": "2026-09-17T07:51:27.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/d9f4f9ab81cfa85e3f6ed33ac1d0476b73cd2999ae9c5d43ff3d09d72a20155e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/35196151149" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.4", "date": "2026-09-17T07:51:22.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/c417da6e24ec089699dea304a6ef67fe63ce66f4bb03846e96ddbc5e326187a0", "status": "success", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/35196151149" }, { "r": "4.7.0", "os": "win", "version": "0.1.4", "date": "2026-09-17T07:50:26.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/b7b6908dd72c1b6b4482be204847aca9353bccf5144c7ba5c2dbb8060fc3af17", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/35196151149" }, { "r": "4.5.3", "os": "win", "version": "0.1.4", "date": "2026-09-17T07:50:52.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/f99b0d92ee84796c2a3ff4982a693bdd98177be0657a393ce4ea5175876d6254", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/35196151149" }, { "r": "4.6.1", "os": "win", "version": "0.1.4", "date": "2026-09-17T07:50:15.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/8b5ad26a81ca6a0b726ebd4263ad5bcdd03735bf816df374c889ea92cd293284", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/35196151149" } ] }