{
  "_id": "6aacf4053d719c1f8407384c",
  "Package": "SQLove",
  "Title": "Execute 'SQL' Scripts in 'R' Containing Multiple Queries",
  "Version": "1.0.2",
  "Authors@R": "person(\"Kerns\", \"Sam\", , \"samwkerns@gmail.com\", role = c(\"aut\", \"cre\"))",
  "Description": "The nature of working with structured query language\n('SQL') scripts efficiently often requires the creation of\ntemporary tables and there are few clean and simple 'R' 'SQL'\nexecution approaches that allow you to complete this kind of\nwork with the 'R' environment. This package seeks to give 'SQL'\nimplementations in 'R' a little love by deploying functions\nthat allow you to deploy complex 'SQL' scripts within a typical\n'R' workflow.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.2.3",
  "VignetteBuilder": "knitr",
  "Config/pak/sysreqs": "make default-jdk unixodbc-dev libx11-dev",
  "Repository": "https://samkerns.r-universe.dev",
  "Date/Publication": "2025-04-18 18:50:14 UTC",
  "RemoteUrl": "https://github.com/samkerns/sqlove",
  "RemoteRef": "HEAD",
  "RemoteSha": "9ad293c86b6bcd2a65be8c964a55234cdb774127",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-09-18 07:45:57 UTC",
    "User": "root"
  },
  "Author": "Kerns Sam [aut, cre]",
  "Maintainer": "Kerns Sam <samwkerns@gmail.com>",
  "_user": "samkerns",
  "_type": "src",
  "_file": "SQLove_1.0.2.tar.gz",
  "_fileid": "https://r2.ropensci.org/4ad735bc7fdac3942e5bec8df182712b7f603caf898f0d4ad88b980b584aa181",
  "_filesize": 89902,
  "_sha256": "4ad735bc7fdac3942e5bec8df182712b7f603caf898f0d4ad88b980b584aa181",
  "_expires": "2026-12-27T08:19:15.000Z",
  "_created": "2026-09-18T07:45:57.000Z",
  "_published": "2026-09-18T08:19:17.131Z",
  "_jobs": [
    {
      "job": 105523357016,
      "time": 139,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "10537395933"
    },
    {
      "job": 105523356982,
      "time": 139,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "10536982342"
    },
    {
      "job": 105523357066,
      "time": 149,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "10538135571"
    },
    {
      "job": 105523356963,
      "time": 192,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "10537264688"
    },
    {
      "job": 105522425549,
      "time": 218,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10537276168"
    },
    {
      "job": 105523357064,
      "time": 139,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "10537590530"
    },
    {
      "job": 105523356987,
      "time": 72,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "10537330949"
    },
    {
      "job": 105523356984,
      "time": 64,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "10537092026"
    },
    {
      "job": 105523357008,
      "time": 76,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "10536872491"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/samkerns/actions/runs/35320691803",
  "_status": "success",
  "_upstream": "https://github.com/samkerns/sqlove",
  "_commit": {
    "id": "9ad293c86b6bcd2a65be8c964a55234cdb774127",
    "author": "Samuel Kerns <samuel.kerns@umgc.edu>",
    "committer": "Samuel Kerns <samuel.kerns@umgc.edu>",
    "message": "Oops, spelling error in the README. Classic.\n",
    "time": 1745002214
  },
  "_maintainer": {
    "name": "Kerns Sam",
    "email": "samwkerns@gmail.com",
    "login": "samkerns",
    "description": "Lead Data Scientist | Researcher | Data Storyteller",
    "uuid": 62064156
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "readr",
      "role": "Imports"
    },
    {
      "package": "RJDBC",
      "role": "Imports"
    },
    {
      "package": "odbc",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    }
  ],
  "_owner": "samkerns",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [],
  "_tags": [],
  "_stars": 0,
  "_contributors": [
    {
      "user": "samkerns",
      "count": 1,
      "uuid": 62064156
    }
  ],
  "_userbio": {
    "uuid": 62064156,
    "type": "user",
    "name": "Sam Kerns",
    "followers": 1,
    "description": "Lead Data Scientist | Researcher | Data Storyteller"
  },
  "_downloads": {
    "count": 373,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/SQLove"
  },
  "_devurl": "https://github.com/samkerns/sqlove",
  "_searchresults": 3,
  "_topics": [
    "openjdk"
  ],
  "_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/SQLove.html",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/samkerns/sqlove",
  "_realowner": "samkerns",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.0.1",
      "date": "2023-02-16"
    },
    {
      "version": "0.0.2",
      "date": "2023-03-06"
    },
    {
      "version": "0.0.3",
      "date": "2023-11-10"
    },
    {
      "version": "0.0.4",
      "date": "2023-11-13"
    },
    {
      "version": "1.0.1",
      "date": "2025-04-10"
    },
    {
      "version": "1.0.2",
      "date": "2025-04-17"
    }
  ],
  "_exports": [
    "dbGetMultiQuery",
    "dbSendMultiUpdate"
  ],
  "_help": [
    {
      "page": "dbGetMultiQuery",
      "title": "Query a database with multiple query actions and one, final, select statement.",
      "topics": [
        "dbGetMultiQuery"
      ]
    },
    {
      "page": "dbSendMultiUpdate",
      "title": "Run multiple SQL query actions within the DB environment.",
      "topics": [
        "dbSendMultiUpdate"
      ]
    }
  ],
  "_readme": "https://github.com/samkerns/sqlove/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cli",
    "clipr",
    "cpp11",
    "crayon",
    "DBI",
    "glue",
    "hms",
    "lifecycle",
    "magrittr",
    "odbc",
    "pillar",
    "pkgconfig",
    "prettyunits",
    "progress",
    "R6",
    "Rcpp",
    "readr",
    "rJava",
    "RJDBC",
    "rlang",
    "tibble",
    "tidyselect",
    "tzdb",
    "utf8",
    "vctrs",
    "vroom",
    "withr"
  ],
  "_sysdeps": [
    {
      "shlib": "libjvm",
      "package": "openjdk-25-jre-headless",
      "headers": "openjdk-25-jre-headless",
      "source": "openjdk",
      "version": "25.0.4+7-1~26.04",
      "name": "openjdk",
      "homepage": "https://openjdk.java.net/",
      "description": "OpenJDK Java runtime, using Hotspot JIT (headless)"
    }
  ],
  "_vignettes": [
    {
      "source": "SQLove.Rmd",
      "filename": "SQLove.html",
      "title": "SQLove - Simple Functions for Complex Queries",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "The Problem",
        "dbGetMultiQuery",
        "dbSendMultiUpdate"
      ],
      "created": "2023-02-10 16:38:11",
      "modified": "2025-04-18 15:22:19",
      "commits": 3
    }
  ],
  "_score": 3.6989700043360187,
  "_indexed": true,
  "_nocasepkg": "sqlove",
  "_universes": [
    "samkerns"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.0.2",
      "date": "2026-09-18T07:48:22.000Z",
      "distro": "resolute",
      "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127",
      "fileid": "https://r2.ropensci.org/1758817eda2aa38aa8fd0b94d0680254de02fabe9a630063d7fe91391d4ff36d",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/samkerns/actions/runs/35320691803"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.0.2",
      "date": "2026-09-18T07:48:22.000Z",
      "distro": "resolute",
      "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127",
      "fileid": "https://r2.ropensci.org/35ee8f901fa8d4ed36763d4cfe41de71f3074b4105af69cf1a18c20dafe59906",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/samkerns/actions/runs/35320691803"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.0.2",
      "date": "2026-09-18T08:18:03.000Z",
      "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127",
      "fileid": "https://r2.ropensci.org/79263ae5724772458d30ec50aca48820ce3e2f889900318d923acde8a87d3ced",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/samkerns/actions/runs/35320691803"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.0.2",
      "date": "2026-09-18T08:16:58.000Z",
      "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127",
      "fileid": "https://r2.ropensci.org/7fc2a296d9071b46375a28b794b65f943a53c521b011add3e057e7dc731ef9e9",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/samkerns/actions/runs/35320691803"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.0.2",
      "date": "2026-09-18T07:48:33.000Z",
      "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127",
      "fileid": "https://r2.ropensci.org/ff3541fc3170ab4f505ff58dd4de7d54b3ac355109add0fb5eec349c26cf7ff2",
      "status": "success",
      "buildurl": "https://github.com/r-universe/samkerns/actions/runs/35320691803"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.0.2",
      "date": "2026-09-18T07:47:12.000Z",
      "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127",
      "fileid": "https://r2.ropensci.org/d0001998d4ed232acdd180194a6e45f7d724be693815daacfeeff394dd6bf278",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/samkerns/actions/runs/35320691803"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.0.2",
      "date": "2026-09-18T07:47:06.000Z",
      "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127",
      "fileid": "https://r2.ropensci.org/50b683ee11fad4b31b9cf2e7a48bd36a57abd19d989d169d8479f0a72457c298",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/samkerns/actions/runs/35320691803"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.0.2",
      "date": "2026-09-18T07:47:16.000Z",
      "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127",
      "fileid": "https://r2.ropensci.org/4fc01e4cad9986fb1867e40ae6806ec7ea3349e825228c783cb9710e208b141f",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/samkerns/actions/runs/35320691803"
    }
  ]
}