R (prqlr)

R bindings for prql-compiler. Check out https://eitsupi.github.io/prqlr/ for more context.

Note

prqlr is generously maintained by @eitsupi in the eitsupi/prqlr repo.

Installation

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

Usage

library(prqlr)

"
from employees
join salaries [emp_id]
group [dept_id, gender] (
  aggregate [
    avg_salary = average salary
  ]
)
" |>
  prql_to_sql()