sqlq: 'SQL' Query Builder

Allows to build complex 'SQL' (Structured Query Language) queries dynamically. Classes and/or factory functions are used to produce a syntax tree from which the final character string is generated. Strings and identifiers are automatically quoted using the right quotes, using either ANSI (American National Standards Institute) quoting or the quoting style of an existing database connector. Style can be configured to set uppercase/lowercase for keywords, remove unnecessary spaces, or omit optional keywords.

Version: 1.0.1
Depends: R (≥ 4.1)
Imports: R6, chk, DBI
Suggests: roxygen2, testthat, knitr, rmarkdown, covr, cyclocomp, lintr, lgr, RSQLite
Published: 2025-09-16
Author: Pierrick Roger ORCID iD [aut, cre]
Maintainer: Pierrick Roger <pierrick.roger at cea.fr>
BugReports: https://gitlab.com/cnrgh/databases/r-sqlq/-/issues
License: AGPL-3
URL: https://gitlab.com/cnrgh/databases/r-sqlq
NeedsCompilation: no
CRAN checks: sqlq results

Documentation:

Reference manual: sqlq.html , sqlq.pdf
Vignettes: Introduction to sqlq package (source, R code)

Downloads:

Package source: sqlq_1.0.1.tar.gz
Windows binaries: r-devel: not available, r-release: not available, r-oldrel: not available
macOS binaries: r-release (arm64): not available, r-oldrel (arm64): not available, r-release (x86_64): not available, r-oldrel (x86_64): not available

Linking:

Please use the canonical form https://CRAN.R-project.org/package=sqlq to link to this page.