{ "_id": "6a104180acfb0bcc41c9d7e0", "Package": "sqltargets", "Type": "Package", "Title": "'Targets' Extension for 'SQL' Queries", "Version": "0.3.0", "Authors@R": "c(\nperson(\"David\", \"Ranzolin\", email = \"daranzolin@gmail.com\", role=c(\"aut\", \"cre\", \"cph\")),\nperson(\"Roy\", \"Storey\", email = \"kiwiroy@protonmail.com\", role=c(\"ctb\"), comment=c(ORCID=\"0000-0003-1375-7136\"))\n)", "Maintainer": "David Ranzolin ", "Description": "Provides an extension for 'SQL' queries as separate file\nwithin 'targets' pipelines. The shorthand creates two targets,\nthe query file and the query result.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "URL": "https://github.com/daranzolin/sqltargets", "BugReports": "https://github.com/daranzolin/sqltargets/issues", "RoxygenNote": "7.2.1", "Config/testthat/edition": "3", "Config/pak/sysreqs": "cmake libglpk-dev make libicu-dev libuv1-dev\nlibxml2-dev libx11-dev", "Repository": "https://daranzolin.r-universe.dev", "Date/Publication": "2025-11-12 17:40:51 UTC", "RemoteUrl": "https://github.com/daranzolin/sqltargets", "RemoteRef": "HEAD", "RemoteSha": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-11 07:47:05 UTC", "User": "root" }, "Author": "David Ranzolin [aut, cre, cph],\nRoy Storey [ctb] (ORCID: )", "MD5sum": "b7c34dfa7537e71a6e870c2efb3958e5", "_user": "daranzolin", "_type": "src", "_file": "sqltargets_0.3.0.tar.gz", "_fileid": "1205bff9784e7c523a35d7e6eebaca2423a804f1f46a94dc79183285df75e79b", "_filesize": 230741, "_sha256": "1205bff9784e7c523a35d7e6eebaca2423a804f1f46a94dc79183285df75e79b", "_created": "2026-05-11T07:47:05.000Z", "_published": "2026-05-22T11:44:00.584Z", "_distro": "noble", "_jobs": [ { "job": 77372699873, "time": 134, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "6912984914" }, { "job": 77372700144, "time": 125, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "6912982172" }, { "job": 77372700403, "time": 149, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "6912978515" }, { "job": 77372700303, "time": 195, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "6912983806" }, { "job": 77372699905, "time": 157, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "6912942057" }, { "job": 77372699650, "time": 136, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7159670009" }, { "job": 77372700341, "time": 239, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "6913016296" }, { "job": 77372700139, "time": 226, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "6913011310" }, { "job": 77372699906, "time": 85, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "6912968230" } ], "_buildurl": "https://github.com/r-universe/daranzolin/actions/runs/25657114045", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/daranzolin/sqltargets", "_commit": { "id": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c", "author": "Roy Storey ", "committer": "GitHub ", "message": "\"catch\" query does not require parameters (#27)\n\n", "time": 1762969251 }, "_maintainer": { "name": "David Ranzolin", "email": "daranzolin@gmail.com", "login": "daranzolin", "twitter": "@daranzolin", "uuid": 9537384 }, "_registered": true, "_dependencies": [ { "package": "cli", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "fs", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "jinjar", "role": "Imports" }, { "package": "purrr", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "tarchetypes", "role": "Imports" }, { "package": "targets", "role": "Imports" }, { "package": "withr", "role": "Imports" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "RSQLite", "version": ">= 2.2.0", "role": "Suggests" } ], "_owner": "daranzolin", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-46", "n": 7 } ], "_tags": [ { "name": "v0.3.0", "date": "2025-11-10" } ], "_topics": [ "pipeline", "sql", "targets", "workflow" ], "_stars": 41, "_contributors": [ { "user": "daranzolin", "count": 54, "uuid": 9537384 }, { "user": "kiwiroy", "count": 3, "uuid": 313562 }, { "user": "jennybc", "count": 1, "uuid": 599454 } ], "_userbio": { "uuid": 9537384, "type": "user", "name": "David Ranzolin", "description": "Data Analyst and Analytics Developer" }, "_downloads": { "count": 176, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqltargets" }, "_devurl": "https://github.com/daranzolin/sqltargets", "_searchresults": 21, "_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/sqltargets.html", "manual.pdf" ], "_homeurl": "https://github.com/daranzolin/sqltargets", "_realowner": "daranzolin", "_cranurl": true, "_releases": [ { "version": "0.0.1", "date": "2024-04-24" }, { "version": "0.1.0", "date": "2024-06-20" }, { "version": "0.2.0", "date": "2024-07-31" }, { "version": "0.2.1", "date": "2024-10-02" }, { "version": "0.3.0", "date": "2025-11-10" } ], "_exports": [ "sqltargets_option_get", "sqltargets_option_set", "tar_sql", "tar_sql_deps", "tar_sql_exec", "tar_sql_file", "tar_sql_raw" ], "_help": [ { "page": "sqltargets", "title": "'sqltargets' package", "topics": [ "sqltargets" ] }, { "page": "sqltargets-options", "title": "Get or Set sqltargets Options", "topics": [ "sqltargets_option_get", "sqltargets_option_set" ] }, { "page": "tar_sql", "title": "Target with a SQL query.", "topics": [ "tar_sql" ] }, { "page": "tar_sql_deps", "title": "List SQL query dependencies.", "concept": [ "SQL query utilities" ], "topics": [ "tar_sql_deps" ] }, { "page": "tar_sql_raw", "title": "Target with a SQL query.", "topics": [ "tar_sql_raw" ] } ], "_pkglogo": "https://github.com/daranzolin/sqltargets/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/daranzolin/sqltargets/raw/HEAD/README.md", "_rundeps": [ "backports", "base64url", "bit", "bit64", "callr", "cli", "clipr", "codetools", "cpp11", "crayon", "data.table", "DBI", "dplyr", "evaluate", "fs", "generics", "glue", "highr", "hms", "igraph", "jinjar", "jsonlite", "knitr", "lattice", "lifecycle", "magrittr", "Matrix", "pillar", "pkgconfig", "prettyunits", "processx", "progress", "ps", "purrr", "R6", "readr", "rlang", "secretbase", "stringi", "stringr", "tarchetypes", "targets", "tibble", "tidyselect", "tzdb", "utf8", "vctrs", "vroom", "withr", "xfun", "yaml" ], "_score": 4.935003151453655, "_indexed": true, "_nocasepkg": "sqltargets", "_universes": [ "daranzolin" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.0", "date": "2026-05-11T07:49:21.000Z", "distro": "noble", "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c", "fileid": "b0f7895e3d4c990e4c5eb938eb3f8556938f49b8618844d04f0d8c4453fc1dee", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/25657114045" }, { "r": "4.6.0", "os": "linux", "version": "0.3.0", "date": "2026-05-11T07:49:12.000Z", "distro": "noble", "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c", "fileid": "6e276d941b42958fb5251b1e7970b9806f039b4cc8d722ca46d275521161a9f3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/25657114045" }, { "r": "4.5.3", "os": "mac", "version": "0.3.0", "date": "2026-05-11T07:49:06.000Z", "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c", "fileid": "ff019dc221e5b2b1821765c88ba90843836695127a40afee749414279aab9aba", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/25657114045" }, { "r": "4.6.0", "os": "mac", "version": "0.3.0", "date": "2026-05-11T07:49:15.000Z", "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c", "fileid": "378ae85fc1b6e5e7d7334c8b414a1be53d701e2a25253769000d0b9657e32a0e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/25657114045" }, { "r": "4.7.0", "os": "win", "version": "0.3.0", "date": "2026-05-11T07:50:52.000Z", "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c", "fileid": "ec93a56cb246eb9b1267fdd9f1e36e78fe837fb363cf4aafe9bebb0b32d3dbed", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/25657114045" }, { "r": "4.5.3", "os": "win", "version": "0.3.0", "date": "2026-05-11T07:50:39.000Z", "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c", "fileid": "d5e833cee467a8b19fe662eac2399fa98821e7671efc3d6203623ea1f9de8233", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/25657114045" }, { "r": "4.6.0", "os": "win", "version": "0.3.0", "date": "2026-05-11T07:48:15.000Z", "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c", "fileid": "b6034dd80b3b3a51c69faecb56c6de682406e0e9b5d066aa9c2bd3c55b5e294b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/25657114045" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.0", "date": "2026-05-22T11:43:41.000Z", "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c", "fileid": "49d60de7d111833aa1275a82bbf7c663278cee37afc4db6e42b3365b0a35b09a", "status": "success", "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/25657114045" } ] }