{
  "_id": "69f4432f878d1f7edaf92ae7",
  "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.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-05-01 05:42:29 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>",
  "MD5sum": "67c69497cb60cfb0f9dd37f93d9e3675",
  "_user": "r-multiverse",
  "_type": "src",
  "_file": "prqlr_0.10.1.tar.gz",
  "_fileid": "d743986dc002198ed6b48c5ef5fb4abb3c70b514eb95c354c0160401a3d15394",
  "_filesize": 196523,
  "_sha256": "d743986dc002198ed6b48c5ef5fb4abb3c70b514eb95c354c0160401a3d15394",
  "_created": "2026-05-01T05:42:29.000Z",
  "_published": "2026-05-01T06:07:43.497Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 73900622584,
      "time": 180,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6745710551"
    },
    {
      "job": 73900622574,
      "time": 180,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6745710511"
    },
    {
      "job": 73900622585,
      "time": 174,
      "config": "linux-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6745709454"
    },
    {
      "job": 73900622579,
      "time": 179,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6745710375"
    },
    {
      "job": 73900622571,
      "time": 171,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6745857660"
    },
    {
      "job": 73900622583,
      "time": 321,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6745900238"
    },
    {
      "job": 73900622567,
      "time": 102,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "WARNING",
      "artifact": "6745833450"
    },
    {
      "job": 73900622572,
      "time": 224,
      "config": "macos-release-x86_64",
      "r": "4.6.0",
      "check": "WARNING",
      "artifact": "6745858159"
    },
    {
      "job": 73900361779,
      "time": 210,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6745683220"
    },
    {
      "job": 73900622540,
      "time": 262,
      "config": "wasm-release",
      "r": "4.5.1",
      "check": "OK",
      "artifact": "6745723150"
    },
    {
      "job": 73900622564,
      "time": 159,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6745707758"
    },
    {
      "job": 73900622555,
      "time": 144,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6745705210"
    },
    {
      "job": 73900622559,
      "time": 151,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6745706602"
    }
  ],
  "_buildurl": "https://github.com/r-universe/r-multiverse/actions/runs/25203898554",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/PRQL/prqlc-r",
  "_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
  },
  "_maintainer": {
    "name": "Tatsuya Shima",
    "email": "ts1s1andn@gmail.com",
    "login": "eitsupi",
    "mastodon": "@eitsupi@fosstodon.org",
    "twitter": "@eitsupi",
    "uuid": 50911393
  },
  "_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": 58,
  "_contributors": [
    {
      "user": "eitsupi",
      "count": 315,
      "uuid": 50911393
    },
    {
      "user": "yutannihilation",
      "count": 1,
      "uuid": 1978793
    },
    {
      "user": "sorhawell",
      "count": 1,
      "uuid": 8015271
    },
    {
      "user": "yihui",
      "count": 1,
      "uuid": 163582
    }
  ],
  "_userbio": {
    "uuid": 161461790,
    "type": "organization",
    "name": "R-multiverse",
    "description": "A community-curated collection of R package releases, powered by R-universe"
  },
  "_downloads": {
    "count": 728,
    "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": 18,
  "_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/prqlr.html",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_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.495821753385906,
  "_indexed": false,
  "_nocasepkg": "prqlr",
  "_universes": [
    "r-multiverse"
  ],
  "_indexurl": "https://prql.r-universe.dev/prqlr",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.10.1",
      "date": "2026-05-01T05:45:38.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "18a78d8f4e703a957a06764e5a5ddac7d6aa893ea71d45b46c97a6b35723a797",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse/actions/runs/25203898554"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.10.1",
      "date": "2026-05-01T05:45:33.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "1d274f62793914f6fb1d26d6d20509b2e089148104d08c2eba9e36512af84a5a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse/actions/runs/25203898554"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.10.1",
      "date": "2026-05-01T05:45:30.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "89b3a27ebef1b55a8b8b10772c0af799ec89adf5603cd9ffc891c860a485c092",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse/actions/runs/25203898554"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.10.1",
      "date": "2026-05-01T05:45:32.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "f46fdb6427c345eec55539fe843036876d39ab2e2f8a26c58830c17a33936cbc",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse/actions/runs/25203898554"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.10.1",
      "date": "2026-05-01T06:02:21.000Z",
      "arch": "aarch64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "c51357fe42718610803e492845ad748e478ee88cbba35baaeb4df1a05e814303",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse/actions/runs/25203898554"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.10.1",
      "date": "2026-05-01T06:06:36.000Z",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "ef30bdd9b6a33aa76acbd5132a36af5ce2ac5ac51640b7eb73fe95e777f11cf7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse/actions/runs/25203898554"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.10.1",
      "date": "2026-05-01T05:59:40.000Z",
      "arch": "aarch64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "54a43a6407e3e346af27d12cdce6ec738aef6c7d5e45ff583462ec6eb8408913",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/r-multiverse/actions/runs/25203898554"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.10.1",
      "date": "2026-05-01T06:02:19.000Z",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "5d4dc59ce53c6d74c273e86677bedac7f4702c75d8e397d712ad4503c45d3538",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/r-multiverse/actions/runs/25203898554"
    },
    {
      "r": "4.5.1",
      "os": "wasm",
      "version": "0.10.1",
      "date": "2026-05-01T05:45:07.000Z",
      "arch": "emscripten",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "0c3e3f337300f875d33fdf9366eccf6af5269892241a64cd555b74afb79ac191",
      "status": "success",
      "buildurl": "https://github.com/r-universe/r-multiverse/actions/runs/25203898554"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.10.1",
      "date": "2026-05-01T05:44:12.000Z",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "d56c69b78b17e487b0e1712557e3a650813ff06842d2c16ba1f6bb156c4ad7a8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse/actions/runs/25203898554"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.10.1",
      "date": "2026-05-01T05:43:51.000Z",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "83c7eed60e3a67f9b868b8803717e1236448688648bf81d70e8df1bfdc9b0ef7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse/actions/runs/25203898554"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.10.1",
      "date": "2026-05-01T05:44:01.000Z",
      "arch": "x86_64",
      "commit": "85d9fa32cf35a189942953a873a5351b1fae2516",
      "fileid": "a07538436ab76c98e7d1209d770e05f79f34bebcddeebac59cf5f3885ce92a3f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-multiverse/actions/runs/25203898554"
    }
  ]
}