{
  "_id": "6afad5da8c54a69a6a55b5cc",
  "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-11-16 09:35:13 UTC",
    "User": "root"
  },
  "Author": "William Brannon [aut, cre]",
  "Maintainer": "William Brannon <wwbrannon@email.wm.edu>",
  "_user": "wwbrannon",
  "_type": "src",
  "_file": "sqlscore_0.1.4.tar.gz",
  "_fileid": "https://r2.ropensci.org/f60276ec6b21411abfbf436be43bd628b23e52401699098f556df67c6abb1171",
  "_filesize": 116363,
  "_sha256": "f60276ec6b21411abfbf436be43bd628b23e52401699098f556df67c6abb1171",
  "_expires": "2027-02-24T10:07:20.000Z",
  "_created": "2026-11-16T09:35:13.000Z",
  "_published": "2026-11-16T10:07:22.362Z",
  "_upstream": "https://github.com/wwbrannon/sqlscore",
  "_status": "success",
  "_maintainer": {
    "name": "William Brannon",
    "email": "wwbrannon@email.wm.edu"
  },
  "_jobs": [
    {
      "job": 133209713111,
      "time": 159,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "14213127583"
    },
    {
      "job": 133209712448,
      "time": 107,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14213366625"
    },
    {
      "job": 133209712540,
      "time": 189,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "14214503059"
    },
    {
      "job": 133209712559,
      "time": 272,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14215730162"
    },
    {
      "job": 133208002379,
      "time": 204,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14211644942"
    },
    {
      "job": 133209712642,
      "time": 91,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "14212244953"
    },
    {
      "job": 133209712495,
      "time": 66,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "14213445825"
    },
    {
      "job": 133209712506,
      "time": 76,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "14212318920"
    },
    {
      "job": 133209712580,
      "time": 57,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14212404792"
    }
  ],
  "_buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/43840560898",
  "_commit": {
    "id": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba",
    "author": "William Brannon <will.brannon@gmail.com>",
    "committer": "William Brannon <will.brannon@gmail.com>",
    "message": "update LICENSE year\n",
    "time": 1552841313
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_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": 30
  },
  "_downloads": {
    "count": 149,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlscore"
  },
  "_devurl": "https://github.com/wwbrannon/sqlscore",
  "_rbuild": "4.6.2",
  "_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.845098040014257,
  "_indexed": true,
  "_nocasepkg": "sqlscore",
  "_universes": [
    "wwbrannon"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.4",
      "date": "2026-11-16T09:37:56.000Z",
      "distro": "resolute",
      "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba",
      "fileid": "https://r2.ropensci.org/1698b13f16e17544ae87d04b98af9cbe9cc1f508dfc787d0d605a44d99feb692",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/43840560898"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.1.4",
      "date": "2026-11-16T09:37:06.000Z",
      "distro": "resolute",
      "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba",
      "fileid": "https://r2.ropensci.org/168c4edbec78f317392cbf5c050ad93c2ff541f763fd591cfa501a898cf9fb8d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/43840560898"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.4",
      "date": "2026-11-16T10:00:24.000Z",
      "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba",
      "fileid": "https://r2.ropensci.org/70f9f3dad07bcd4c01981cb642e4d9cc812c1a917afc57be27619dbf7a7bb868",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/43840560898"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "0.1.4",
      "date": "2026-11-16T10:05:20.000Z",
      "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba",
      "fileid": "https://r2.ropensci.org/edfab4a0018bf84fbdd77255ea656baac139932109aa2c29d251e924cc2f0b81",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/43840560898"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.4",
      "date": "2026-11-16T09:37:00.000Z",
      "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba",
      "fileid": "https://r2.ropensci.org/8dceb4ffc85648334211a28a26bd69a4571f6c6206623663c2ade309efb222b3",
      "status": "success",
      "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/43840560898"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.4",
      "date": "2026-11-16T09:36:15.000Z",
      "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba",
      "fileid": "https://r2.ropensci.org/2e748f01ef4258c0b2dec36ba675434667df22060a01afaa488695a780d46cdc",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/43840560898"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.4",
      "date": "2026-11-16T09:36:28.000Z",
      "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba",
      "fileid": "https://r2.ropensci.org/9725d420fe46de23ccabbd8f0b04e2c8e80f72068ba0b17533106a198defab3d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/43840560898"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "0.1.4",
      "date": "2026-11-16T09:36:13.000Z",
      "commit": "9d0093f2cba63bb04c83d05dc45c3c78b9ae23ba",
      "fileid": "https://r2.ropensci.org/e8b7f7c65be8413c413dbe4a8caeb48ab1c0c84de118afd39321e163fcbdc0fb",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/wwbrannon/actions/runs/43840560898"
    }
  ]
}