{
  "_id": "6ae9e866818c9e3ef6dbfe7b",
  "Package": "prqlr",
  "Title": "R Bindings for the 'prqlc' Rust Library",
  "Description": "Provides a function to convert 'PRQL' strings to 'SQL'\nstrings. Combined with other R functions that take 'SQL' as an\nargument, 'PRQL' can be used on R.",
  "Version": "0.10.1",
  "Authors@R": "c(person(\"Tatsuya\", \"Shima\", email = \"ts1s1andn@gmail.com\", role = c(\"aut\", \"cre\")),\nperson(\"Authors of the dependency Rust crates\", role = \"aut\",\ncomment = \"see inst/AUTHORS file for details\"))",
  "URL": "https://prql.github.io/prqlc-r/, https://github.com/PRQL/prqlc-r",
  "BugReports": "https://github.com/PRQL/prqlc-r/issues",
  "License": "MIT + file LICENSE",
  "Language": "en-US",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.2",
  "SystemRequirements": "Cargo (Rust's package manager), rustc",
  "VignetteBuilder": "knitr",
  "Config/testthat/edition": "3",
  "Config/testthat/parallel": "true",
  "Config/Needs/dev": "brio, devtools, xfun (>= 0.44), lintr, styler, purrr,\nRcppTOML, readr, tidyr, rhub",
  "Config/Needs/website": "pkgdown",
  "Config/prqlr/LibVersion": "0.13.2",
  "Config/pak/sysreqs": "libclang-dev",
  "Repository": "https://r-multiverse-staging.r-universe.dev",
  "Date/Publication": "2025-03-28 12:37:31 UTC",
  "RemoteUrl": "https://github.com/PRQL/prqlc-r",
  "RemoteRef": "v0.10.1",
  "RemoteSha": "85d9fa32cf35a189942953a873a5351b1fae2516",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-11-03 13:36:11 UTC",
    "User": "root"
  },
  "Author": "Tatsuya Shima [aut, cre],\nAuthors of the dependency Rust crates [aut] (see inst/AUTHORS file for\ndetails)",
  "Maintainer": "Tatsuya Shima <ts1s1andn@gmail.com>",
  "_user": "r-multiverse-staging",
  "_type": "src",
  "_file": "prqlr_0.10.1.tar.gz",
  "_fileid": "https://r2.ropensci.org/71da40d84ecaf86b7bc39da1653969632c567405d9cc10ae3d9e2c378c2ec183",
  "_filesize": 196569,
  "_sha256": "71da40d84ecaf86b7bc39da1653969632c567405d9cc10ae3d9e2c378c2ec183",
  "_expires": "2027-02-11T13:57:56.000Z",
  "_created": "2026-11-03T13:36:11.000Z",
  "_published": "2026-11-03T13:57:58.433Z",
  "_upstream": "https://github.com/PRQL/prqlc-r",
  "_status": "success",
  "_maintainer": {
    "name": "Tatsuya Shima",
    "email": "ts1s1andn@gmail.com",
    "login": "eitsupi",
    "mastodon": "@eitsupi@fosstodon.org",
    "twitter": "@eitsupi",
    "description": "",
    "uuid": 50911393
  },
  "_jobs": [
    {
      "job": 125950877033,
      "time": 497,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13234874451"
    },
    {
      "job": 125950877228,
      "time": 593,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13235506409"
    },
    {
      "job": 125950877281,
      "time": 102,
      "config": "linux-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13234452505"
    },
    {
      "job": 125950877107,
      "time": 136,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13234529481"
    },
    {
      "job": 125950877055,
      "time": 97,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13234448769"
    },
    {
      "job": 125950877062,
      "time": 255,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13234493947"
    },
    {
      "job": 125950876985,
      "time": 130,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "WARNING",
      "artifact": "13234889042"
    },
    {
      "job": 125950877220,
      "time": 146,
      "config": "macos-release-x86_64",
      "r": "4.6.2",
      "check": "WARNING",
      "artifact": "13234928448"
    },
    {
      "job": 125949195623,
      "time": 188,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13234771953"
    },
    {
      "job": 125950877184,
      "time": 239,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "13234973874"
    },
    {
      "job": 125950877067,
      "time": 1197,
      "config": "windows-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13235648328"
    },
    {
      "job": 125950877058,
      "time": 679,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13236150911"
    },
    {
      "job": 125950877266,
      "time": 147,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13234503396"
    },
    {
      "job": 125950877250,
      "time": 1265,
      "config": "windows-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13236596753"
    },
    {
      "job": 125950877003,
      "time": 137,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13233908990"
    }
  ],
  "_buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317",
  "_commit": {
    "id": "85d9fa32cf35a189942953a873a5351b1fae2516",
    "author": "eitsupi <ts1s1andn@gmail.com>",
    "committer": "eitsupi <ts1s1andn@gmail.com>",
    "message": "chore: update cran-comments to excuse the tarball size\n",
    "time": 1743165451
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.2",
      "role": "Depends"
    },
    {
      "package": "knitr",
      "version": ">= 1.44",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "DBI",
      "role": "Suggests"
    },
    {
      "package": "glue",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    },
    {
      "package": "tidyquery",
      "role": "Suggests"
    },
    {
      "package": "sqldf",
      "role": "Suggests"
    },
    {
      "package": "nycflights13",
      "role": "Suggests"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.2.0",
      "role": "Suggests"
    },
    {
      "package": "patrick",
      "version": ">= 0.3.0",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    },
    {
      "package": "cli",
      "role": "Suggests"
    }
  ],
  "_owner": "prql",
  "_selfowned": false,
  "_usedby": 0,
  "_updates": [],
  "_tags": [],
  "_topics": [
    "prql",
    "rust",
    "sql"
  ],
  "_stars": 59,
  "_contributors": [
    {
      "user": "eitsupi",
      "count": 315,
      "uuid": 50911393
    },
    {
      "user": "yutannihilation",
      "count": 1,
      "uuid": 1978793
    },
    {
      "user": "jeroen",
      "count": 1,
      "uuid": 216319
    },
    {
      "user": "sorhawell",
      "count": 1,
      "uuid": 8015271
    },
    {
      "user": "yihui",
      "count": 1,
      "uuid": 163582
    }
  ],
  "_userbio": {
    "uuid": 161461790,
    "type": "organization",
    "name": "R-multiverse",
    "followers": 38,
    "description": "A community-curated collection of R package releases, powered by R-universe"
  },
  "_downloads": {
    "count": 514,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/prqlr"
  },
  "_devurl": "https://github.com/prql/prqlc-r",
  "_pkgdown": "https://prql.github.io/prqlc-r/",
  "_searchresults": 20,
  "_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/prqlr.html",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/prql/prqlc-r",
  "_realowner": "prql",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2023-01-20"
    },
    {
      "version": "0.2.0",
      "date": "2023-02-18"
    },
    {
      "version": "0.2.1",
      "date": "2023-02-28"
    },
    {
      "version": "0.3.0",
      "date": "2023-03-16"
    },
    {
      "version": "0.4.0",
      "date": "2023-04-30"
    },
    {
      "version": "0.5.0",
      "date": "2023-08-13"
    },
    {
      "version": "0.5.1",
      "date": "2023-08-30"
    },
    {
      "version": "0.5.2",
      "date": "2023-09-11"
    },
    {
      "version": "0.5.3",
      "date": "2023-09-22"
    },
    {
      "version": "0.5.4",
      "date": "2023-10-07"
    },
    {
      "version": "0.6.0",
      "date": "2023-11-14"
    },
    {
      "version": "0.7.0",
      "date": "2024-01-08"
    },
    {
      "version": "0.8.0",
      "date": "2024-02-14"
    },
    {
      "version": "0.8.1",
      "date": "2024-05-19"
    },
    {
      "version": "0.9.0",
      "date": "2024-09-20"
    },
    {
      "version": "0.10.0",
      "date": "2025-01-29"
    },
    {
      "version": "0.10.1",
      "date": "2025-03-28"
    }
  ],
  "_exports": [
    "prql_compile",
    "prql_get_targets",
    "prql_version"
  ],
  "_help": [
    {
      "page": "prql_compile",
      "title": "Compile a PRQL query into a SQL query",
      "topics": [
        "prql_compile"
      ]
    },
    {
      "page": "prql_get_targets",
      "title": "Get available target names",
      "topics": [
        "prql_get_targets"
      ]
    },
    {
      "page": "prql_version",
      "title": "prqlc's version",
      "topics": [
        "prql_version"
      ]
    }
  ],
  "_pkglogo": "https://github.com/PRQL/prqlc-r/raw/v0.10.1/man/figures/logo.png",
  "_readme": "https://github.com/PRQL/prqlc-r/raw/v0.10.1/README.md",
  "_rundeps": [],
  "_vignettes": [
    {
      "source": "prqlr.Rmd",
      "filename": "prqlr.html",
      "title": "Use PRQL on R",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Work with DB",
        "Work with R Data Frames"
      ],
      "created": "2022-10-23 15:25:28",
      "modified": "2023-12-23 06:06:27",
      "commits": 20
    },
    {
      "source": "knitr.Rmd",
      "filename": "knitr.html",
      "title": "Use PRQL with knitr",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Output formats",
        "Use with {DBI} connections",
        "Without database connections",
        "Engine options",
        "Compiler options",
        "Parameterized PRQL code blocks",
        "Use query strings in R code blocks",
        "Set special info string to output SQL code blocks"
      ],
      "created": "2023-01-27 14:34:33",
      "modified": "2023-12-23 06:06:27",
      "commits": 10
    }
  ],
  "_score": 6.673941998634088,
  "_indexed": false,
  "_nocasepkg": "prqlr",
  "_universes": [
    "r-multiverse-staging"
  ],
  "_indexurl": "https://prql.r-universe.dev/prqlr",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.10.1",
      "date": "2026-11-03T13:44:38.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/41d08b97fe64572eeecbee961f63e6ca6fe2d3df224c0f8ed66d771d9a7aef1d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.10.1",
      "date": "2026-11-03T13:46:02.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/4f50f198e1d08d37a2cdabf64bec199b1192649735b80469e5318fe45c5778ef",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.10.1",
      "date": "2026-11-03T13:38:06.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/31710ea49aafd8968ec6e78fe6f1a0b794f99c8237b320646dd0006c195e1e8b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.10.1",
      "date": "2026-11-03T13:38:32.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/5c88e10b312d40a55879b5937effda616b662df593ffbed220c13bf4eff1f466",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.10.1",
      "date": "2026-11-03T13:40:05.000Z",
      "arch": "aarch64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/40380cd8bb768d54216487e45779e9c1cef405f2d78adc87aebd3a06fddd6fc7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.10.1",
      "date": "2026-11-03T13:40:53.000Z",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/5f3d91f72e97a3557927d340784b23d3ce6261f879e00d4109337fd6e4958827",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "0.10.1",
      "date": "2026-11-03T13:40:59.000Z",
      "arch": "aarch64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/69b4e0d9a54ff327e74ab0e683b76fed4d9432104eb3312abe97ab1273982541",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "0.10.1",
      "date": "2026-11-03T13:40:03.000Z",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/05eab7310caa775c01ae61ca68287d0816cbd03322783986c23492091db81a03",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.10.1",
      "date": "2026-11-03T13:38:22.000Z",
      "arch": "emscripten",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/31245530cddd444a4001433eb63db1d090dd8cf86ef567c3f98052663f0ac9c6",
      "status": "success",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.10.1",
      "date": "2026-11-03T13:52:31.000Z",
      "arch": "aarch64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/31a64d61464eac490c3661521bd75a85eb8f03bc50b7a55461f67842cf1e7c45",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.10.1",
      "date": "2026-11-03T13:46:28.000Z",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/39fa0933cdc29f2f97a7512cb1b6894666edb1a99762b10081eb0c86ced230a0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.10.1",
      "date": "2026-11-03T13:37:33.000Z",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/e710ad5180f3b79b51155b5d3dc60076b1b7c5fee7bf1ba1a815f97c92cc1408",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "0.10.1",
      "date": "2026-11-03T13:53:48.000Z",
      "arch": "aarch64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/571fe2652c62c9fcaecdb5578004da0d8f30bd7b8395ab81261d8a8ec8717b12",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "0.10.1",
      "date": "2026-11-03T13:37:33.000Z",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "https://r2.ropensci.org/4dd9c6e2e251fbba2f14a715f6c38557037220e303cd0a4ab9ff725c0a413fa4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse-staging/actions/runs/41645317317"
    }
  ]
}