{ "_id": "6a35103c3efcd9bda43de9f0", "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-06-19 09:37:09 UTC", "User": "root" }, "Author": "William Brannon [aut, cre]", "Maintainer": "William Brannon ", "MD5sum": "ad809dcf0dd656268201d6e960610b9d", "_user": "wwbrannon", "_type": "src", "_file": "sqlscore_0.1.4.tar.gz", "_fileid": "4e7d22863e7ec6f739846dde5cfde5fa54bff0c96e9eed11d1aba3944ae5434c", "_filesize": 119139, "_sha256": "4e7d22863e7ec6f739846dde5cfde5fa54bff0c96e9eed11d1aba3944ae5434c", "_created": "2026-06-19T09:37:09.000Z", "_published": "2026-06-19T09:47:40.765Z", "_distro": "noble", "_jobs": [ { "job": 82323639494, "time": 138, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7746534017" }, { "job": 82323639478, "time": 130, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7746531191" }, { "job": 82323639489, "time": 160, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7746680617" }, { "job": 82323639492, "time": 168, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7746676886" }, { "job": 82323156210, "time": 182, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7746486106" }, { "job": 82323639501, "time": 115, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7746526134" }, { "job": 82323639507, "time": 80, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7746518751" }, { "job": 82323639526, "time": 70, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7746511019" }, { "job": 82323639502, "time": 82, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7746515546" } ], "_buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/27817756093", "_status": "success", "_host": "GitHub-Actions", "_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" }, "_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": 63, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlscore" }, "_devurl": "https://github.com/wwbrannon/sqlscore", "_searchresults": 11, "_rbuild": "4.6.0", "_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" ], "_homeurl": "https://github.com/wwbrannon/sqlscore", "_realowner": "wwbrannon", "_cranurl": true, "_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": 3.886490725172482, "_indexed": true, "_nocasepkg": "sqlscore", "_universes": [ "wwbrannon" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.4", "date": "2026-06-19T09:39:31.000Z", "distro": "noble", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "41d0dc84fb6868f18fb272ab80617bab973aab3229683158ae89e9a17aef5234", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/27817756093" }, { "r": "4.6.0", "os": "linux", "version": "0.1.4", "date": "2026-06-19T09:39:22.000Z", "distro": "noble", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "2d6424793156786be7e890cbbd44dabe873f662505ace76f59d7093255488e43", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/27817756093" }, { "r": "4.5.3", "os": "mac", "version": "0.1.4", "date": "2026-06-19T09:46:41.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "b67949f6ef78a4747f9b12fcb53bdbc32f0014b21d64d0bd74c999a3afca66ba", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/27817756093" }, { "r": "4.6.0", "os": "mac", "version": "0.1.4", "date": "2026-06-19T09:46:26.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "02a9b4af7a037cd803596de2b2a2033dfa3008bc229e00cb0d04973337308b81", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/27817756093" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.4", "date": "2026-06-19T09:39:21.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "2f752f3edfabd882fcf0c849564b8cfd2383d5458e71813de0e817f08b215068", "status": "success", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/27817756093" }, { "r": "4.7.0", "os": "win", "version": "0.1.4", "date": "2026-06-19T09:38:40.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "d8033eb75ec39547c2382dcb6f55f44a8c6ee3aa2ef86eb55630085fd79bed01", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/27817756093" }, { "r": "4.5.3", "os": "win", "version": "0.1.4", "date": "2026-06-19T09:38:17.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "05efc6f83aa0bd1f0c6b71d85a61397373f0ba4cb828c31064a124588d4e24bf", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/27817756093" }, { "r": "4.6.0", "os": "win", "version": "0.1.4", "date": "2026-06-19T09:38:30.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "a8a5f7e27439f4c08ae3ea866ac269695b76c6318a7bd1f812143ee461758ae0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/27817756093" } ] }