{ "_id": "6a1ede7cb401979e7341038e", "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-05-20 07:54:31 UTC", "User": "root" }, "Author": "William Brannon [aut, cre]", "Maintainer": "William Brannon ", "MD5sum": "678549cd34db91bbc0d7ed990ae42322", "_user": "wwbrannon", "_type": "src", "_file": "sqlscore_0.1.4.tar.gz", "_fileid": "3ce056ad774e4e972b98fbcd68effd9c564a523fd93027136d337041c95b6e35", "_filesize": 116458, "_sha256": "3ce056ad774e4e972b98fbcd68effd9c564a523fd93027136d337041c95b6e35", "_created": "2026-05-20T07:54:31.000Z", "_published": "2026-06-02T13:45:32.463Z", "_distro": "noble", "_jobs": [ { "job": 79085262355, "time": 129, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7104328401" }, { "job": 79085262660, "time": 170, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7104342747" }, { "job": 79085262377, "time": 142, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7104323961" }, { "job": 79085261729, "time": 160, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7104325870" }, { "job": 79085261082, "time": 233, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7104285568" }, { "job": 79085261174, "time": 121, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7359471186" }, { "job": 79085262816, "time": 83, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7104313607" }, { "job": 79085262713, "time": 78, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7104311973" }, { "job": 79085262528, "time": 83, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7104313347" } ], "_buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/26149059367", "_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" }, "_downloads": { "count": 146, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlscore" }, "_devurl": "https://github.com/wwbrannon/sqlscore", "_searchresults": 8, "_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", "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.845098040014257, "_indexed": true, "_nocasepkg": "sqlscore", "_universes": [ "wwbrannon" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.4", "date": "2026-05-20T07:56:43.000Z", "distro": "noble", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "72b556a4c3711a5d9949a64ed738c73b16226419707a60b4b259eeb66793a305", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/26149059367" }, { "r": "4.6.0", "os": "linux", "version": "0.1.4", "date": "2026-05-20T07:57:25.000Z", "distro": "noble", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "9ddcea502392ecc7f729669a56984451abff8811ea1110733206ff58155cbcb5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/26149059367" }, { "r": "4.5.3", "os": "mac", "version": "0.1.4", "date": "2026-05-20T07:56:36.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "5d38a96a7a67a055d1e2e653d8bf95e501b36e4a7da191bbe5e760a4c9d9a623", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/26149059367" }, { "r": "4.6.0", "os": "mac", "version": "0.1.4", "date": "2026-05-20T07:56:35.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "8f639c969b8bfbb89219e2b45570ad5e48015aa24ccc2f663d489cccff3b0b2f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/26149059367" }, { "r": "4.7.0", "os": "win", "version": "0.1.4", "date": "2026-05-20T07:55:53.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "b8ffc68f99cb15f8694b481fd2ef832978f380f8b39cf8fc2b965b3eaa2e9652", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/26149059367" }, { "r": "4.5.3", "os": "win", "version": "0.1.4", "date": "2026-05-20T07:55:47.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "b4dd7cfed33f22c1ff29272f56d75bb48d390b2485bced8b6ef0847e29bc59af", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/26149059367" }, { "r": "4.6.0", "os": "win", "version": "0.1.4", "date": "2026-05-20T07:55:52.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "691fc7cb30fc4b83ef1c6bfa0dddf7ec209cf32fbdece8b73d33383a41afdf52", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/26149059367" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.4", "date": "2026-06-02T13:45:06.000Z", "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba", "fileid": "04e346b1ee4e7f2ae48d05d83c9e8cc1c0b457e6586597ed010ed8c2755aea01", "status": "success", "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/26149059367" } ] }