Title: R Bindings for the 'prqlc' Rust Library
Description: Provides a function to convert 'PRQL' strings to 'SQL' strings. Combined with other R functions that take 'SQL' as an argument, 'PRQL' can be used on R.
Version: 0.10.1
URL: https://prql.github.io/prqlc-r/, https://github.com/PRQL/prqlc-r
BugReports: https://github.com/PRQL/prqlc-r/issues
Depends: R (≥ 4.2)
Suggests: knitr (≥ 1.44), rmarkdown, DBI, glue, RSQLite, tidyquery, sqldf, nycflights13, dplyr, testthat (≥ 3.2.0), patrick (≥ 0.3.0), withr, cli
License: MIT + file LICENSE
Language: en-US
Encoding: UTF-8
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, RcppTOML, readr, tidyr, rhub
Config/Needs/website: pkgdown
Config/prqlr/LibVersion: 0.13.2
NeedsCompilation: yes
Packaged: 2025-03-28 12:39:23 UTC; rstudio
Author: Tatsuya Shima [aut, cre], Authors of the dependency Rust crates [aut] (see inst/AUTHORS file for details)
Maintainer: Tatsuya Shima <ts1s1andn@gmail.com>
Repository: CRAN
Date/Publication: 2025-03-28 13:10:02 UTC

prqlr: R Bindings for the 'prqlc' Rust Library

Description

logo

Provides a function to convert 'PRQL' strings to 'SQL' strings. Combined with other R functions that take 'SQL' as an argument, 'PRQL' can be used on R.

Author(s)

Maintainer: Tatsuya Shima ts1s1andn@gmail.com

Authors:

See Also

Useful links:


Compile a PRQL query into a SQL query

Description

Compile a PRQL query into a SQL query

Usage

prql_compile(
  prql_query,
  target = getOption("prqlr.target", default = NULL),
  ...,
  format = getOption("prqlr.format", default = TRUE),
  signature_comment = getOption("prqlr.signature_comment", default = TRUE),
  display = getOption("prqlr.display", default = "plain")
)

Arguments

prql_query

A character of PRQL query.

target

A character of the target name to use or NULL. If NULL, the target contained in the query will be used. All available target names can be listed with the prql_get_targets() function.

...

Ignored.

format

A logical flag (default: TRUE). Whether to format the SQL query.

signature_comment

a logical flag. (default: TRUE). Whether to add a signature comment to the output SQL query.

display

A character, one of "plain" (default) or "ansi_color". If "ansi_color", error will be displayed with ANSI color.

Value

A character of the compiled SQL query.

Examples

"from mtcars | filter cyl > 6 | select {cyl, mpg}" |>
  prql_compile()

"from mtcars | filter cyl > 6 | select {cyl, mpg}" |>
  prql_compile(format = FALSE, signature_comment = FALSE)

"
from mtcars
filter cyl > 6
select !{cyl}
" |>
  prql_compile("sql.duckdb") |>
  cat()

# If the `target` argument is `NULL` (default) or `"sql.any"`,
# the target specified in the header of the query will be used.
"
prql target:sql.duckdb

from mtcars
filter cyl > 6
select !{cyl}
" |>
  prql_compile() |>
  cat()

Get available target names

Description

Get available target names for the target option of the prql_compile() function.

Usage

prql_get_targets()

Value

a character vector of target names.

Examples

prql_get_targets()

prqlc's version

Description

prqlc's version

Usage

prql_version()

Value

a numeric_version with the version of the built-in prqlc.

Examples

prql_version()