{
  "_id": "6ac7622bde46216d5edcf31e",
  "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 <daranzolin@gmail.com>",
  "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-10-08 09:13:24 UTC",
    "User": "root"
  },
  "Author": "David Ranzolin [aut, cre, cph],\nRoy Storey [ctb] (ORCID: <https://orcid.org/0000-0003-1375-7136>)",
  "_user": "daranzolin",
  "_type": "src",
  "_file": "sqltargets_0.3.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/02209e14a3eb09d048627fe4fdbec97dbef1c5ae5cf3643ee9101d1c3ae36784",
  "_filesize": 230002,
  "_sha256": "02209e14a3eb09d048627fe4fdbec97dbef1c5ae5cf3643ee9101d1c3ae36784",
  "_expires": "2027-01-16T09:28:09.000Z",
  "_created": "2026-10-08T09:13:24.000Z",
  "_published": "2026-10-08T09:28:10.924Z",
  "_buildurl": "https://github.com/r-universe/daranzolin/actions/runs/37754764178",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 113237876469,
      "time": 129,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11539912351"
    },
    {
      "job": 113237876577,
      "time": 117,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11540051695"
    },
    {
      "job": 113237876641,
      "time": 170,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11539079538"
    },
    {
      "job": 113237876791,
      "time": 168,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11540815695"
    },
    {
      "job": 113236650108,
      "time": 187,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11539029267"
    },
    {
      "job": 113237876538,
      "time": 119,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11540225009"
    },
    {
      "job": 113237876503,
      "time": 84,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11539667472"
    },
    {
      "job": 113237876644,
      "time": 79,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11539184309"
    },
    {
      "job": 113237876609,
      "time": 74,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11539553556"
    }
  ],
  "_upstream": "https://github.com/daranzolin/sqltargets",
  "_commit": {
    "id": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c",
    "author": "Roy Storey <kiwiroy@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "\"catch\" query does not require parameters (#27)\n\n",
    "time": 1762969251
  },
  "_maintainer": {
    "name": "David Ranzolin",
    "email": "daranzolin@gmail.com",
    "login": "daranzolin",
    "bluesky": "@daranzolin.bsky.social",
    "twitter": "@daranzolin",
    "description": "Data Analyst and Analytics Developer",
    "uuid": 9537384
  },
  "_distro": "resolute",
  "_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": 42,
  "_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",
    "followers": 186,
    "description": "Data Analyst and Analytics Developer"
  },
  "_downloads": {
    "count": 308,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqltargets"
  },
  "_devurl": "https://github.com/daranzolin/sqltargets",
  "_searchresults": 21,
  "_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/sqltargets.html",
    "LICENSE"
  ],
  "_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",
    "otel",
    "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.94546858513182,
  "_indexed": true,
  "_nocasepkg": "sqltargets",
  "_universes": [
    "daranzolin"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.3.0",
      "date": "2026-10-08T09:15:32.000Z",
      "distro": "resolute",
      "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c",
      "fileid": "https://r2.ropensci.org/001a9dbacdb8dc04a6fdc77dd0afc18015d4727ae22ffbc391070fa4fef7a63b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/37754764178"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.3.0",
      "date": "2026-10-08T09:15:21.000Z",
      "distro": "resolute",
      "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c",
      "fileid": "https://r2.ropensci.org/5d17952c8c068bb6cc090f89e015d31194461eaf81586b7c9fb74fec1d79c368",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/37754764178"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.3.0",
      "date": "2026-10-08T09:20:41.000Z",
      "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c",
      "fileid": "https://r2.ropensci.org/fb022698de57513354d73d6fae18c5adff1e5fd266817a7dfc59a03b717922c0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/37754764178"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.3.0",
      "date": "2026-10-08T09:26:51.000Z",
      "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c",
      "fileid": "https://r2.ropensci.org/f51df4ec4772d8d964dac53c6ff13db1cceddfe1f72fbd7248e2ac4531e53e99",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/37754764178"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.3.0",
      "date": "2026-10-08T09:15:38.000Z",
      "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c",
      "fileid": "https://r2.ropensci.org/00d4b4241350fa8f84480351a811ec40a3cd543ac80e7a66d530affdd7778237",
      "status": "success",
      "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/37754764178"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.3.0",
      "date": "2026-10-08T09:14:40.000Z",
      "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c",
      "fileid": "https://r2.ropensci.org/88f1066fc2577d252e670e056c7eacddc8c9bad1ec5749817cb4e2d4d49fcf4d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/37754764178"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.3.0",
      "date": "2026-10-08T09:14:34.000Z",
      "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c",
      "fileid": "https://r2.ropensci.org/35d5fd1886dd95e86267339f1142c4a13f1a4894a2be6bb2c05250e2f74848ef",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/37754764178"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.3.0",
      "date": "2026-10-08T09:14:28.000Z",
      "commit": "d4772aa39a402e3ea2bc393d4b1fb6800aa91e6c",
      "fileid": "https://r2.ropensci.org/92da9e875283aa2166391990e677c31a34ffe1be9462e0b0749cc411d1429b7d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/daranzolin/actions/runs/37754764178"
    }
  ]
}