{ "_id": "6a5c7d509baadeef8ab50a47", "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-07-19 07:28:25 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/41dc19f1ed0793b59c07e28fbe28d240f7d191226eb78329a42d3842b1f925c8", "_filesize": 116720, "_sha256": "41dc19f1ed0793b59c07e28fbe28d240f7d191226eb78329a42d3842b1f925c8", "_expires": "2026-10-27T07:31:27.000Z", "_created": "2026-07-19T07:28:25.000Z", "_published": "2026-07-19T07:31:28.590Z", "_jobs": [ { "job": 88169352592, "time": 134, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8439665694" }, { "job": 88169352595, "time": 136, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8439665830" }, { "job": 88169352584, "time": 145, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8439661963" }, { "job": 88169352573, "time": 134, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8439660183" }, { "job": 88169114479, "time": 192, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8439644570" }, { "job": 88169352591, "time": 113, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8439662369" }, { "job": 88169352612, "time": 68, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8439655416" }, { "job": 88169352607, "time": 75, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8439656673" }, { "job": 88169352605, "time": 74, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8439656391" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/29678072570", "_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": 29 }, "_downloads": { "count": 43, "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/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/sqlscore.html", "LICENSE", "manual.pdf" ], "_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-07-19T07:30:39.000Z", "distro": "resolute", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/f481d0c5c92f6410738bd94592bbb1a57493f4dcac862cf990abbb580013e49e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/29678072570" }, { "r": "4.6.1", "os": "linux", "version": "0.1.4", "date": "2026-07-19T07:30:42.000Z", "distro": "resolute", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/e3fe8aee6772daae405220f0babc8fbb78e3f8181ef5c000693fbc364af340a9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/29678072570" }, { "r": "4.5.3", "os": "mac", "version": "0.1.4", "date": "2026-07-19T07:30:20.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/1be5d800dfce6a675690ce251daeb2f6751ce8519da5ba2137a77cad7de16335", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/29678072570" }, { "r": "4.6.1", "os": "mac", "version": "0.1.4", "date": "2026-07-19T07:30:06.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/b89e72b9f7ca1bd910e79440e0920bfe0cc0e12c2b4bc691cb3773ea1fe57b3a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/29678072570" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.4", "date": "2026-07-19T07:30:32.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/0d35e6e231606ca18c96d66f3ecf0370df3f30476672ed38cf8cd1400b335e6b", "status": "success", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/29678072570" }, { "r": "4.7.0", "os": "win", "version": "0.1.4", "date": "2026-07-19T07:29:31.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/238eda7ab2266a1b1b0433d86f747188dea6f921fcff40e6ffaf81f720076e17", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/29678072570" }, { "r": "4.5.3", "os": "win", "version": "0.1.4", "date": "2026-07-19T07:29:36.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/913e6b88639f26434bb3dca30cd820f467b18065c7360e7f8a686537360a19f0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/29678072570" }, { "r": "4.6.1", "os": "win", "version": "0.1.4", "date": "2026-07-19T07:29:34.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "https://r2.ropensci.org/d710263194fd2e442c7c0d175b94c48faef8136a32cfc7596da19fc5024ec5f1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/29678072570" } ] }