prqlr

R bindings for the prql-compiler Rust library, powered by the extendr framework.

Installation

Requires R 4.2.0 or later.

This package can be installed from CRAN or R-universe. If available, a binary package will be installed.

# Install from CRAN
install.packages("prqlr")

# Install from R-universe
install.packages("prqlr", repos = "https://eitsupi.r-universe.dev")

For source installation, the Rust toolchain must be configured. Please check the https://github.com/r-rust/hellorust repository.

Example

library(prqlr)
"from mtcars | filter cyl > 6 | select [cyl, mpg]" |>
  prql_compile() |>
  cat()
#> SELECT
#>   cyl,
#>   mpg
#> FROM
#>   mtcars
#> WHERE
#>   cyl > 6
#> 
#> -- Generated by PRQL compiler version 0.4.0 (https://prql-lang.org)

PRQL’s pipelines can be joined by the newline character (\n), or actual newlines in addition to |.

"from mtcars \n filter cyl > 6 \n select [cyl, mpg]" |>
  prql_compile() |>
  cat()
#> SELECT
#>   cyl,
#>   mpg
#> FROM
#>   mtcars
#> WHERE
#>   cyl > 6
#> 
#> -- Generated by PRQL compiler version 0.4.0 (https://prql-lang.org)

"from mtcars
filter cyl > 6
select [cyl, mpg]" |>
  prql_compile() |>
  cat()
#> SELECT
#>   cyl,
#>   mpg
#> FROM
#>   mtcars
#> WHERE
#>   cyl > 6
#> 
#> -- Generated by PRQL compiler version 0.4.0 (https://prql-lang.org)

Thanks to the {tidyquery} package, we can even convert a PRQL query to a SQL query and then to a {dplyr} query!

"from mtcars
filter cyl > 6
select [cyl, mpg]" |>
  prql_compile() |>
  tidyquery::show_dplyr()
#> mtcars %>%
#>   filter(cyl > 6) %>%
#>   select(cyl, mpg)

Development

Use the rextendr::document() function to generate R source code from Rust source code in the src directory.