'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.


Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("sqlq")

1.0.1 by Pierrick Roger, a year ago


https://gitlab.com/cnrgh/databases/r-sqlq


Report a bug at https://gitlab.com/cnrgh/databases/r-sqlq/-/issues


Browse source code at https://github.com/cran/sqlq


Authors: Pierrick Roger [aut, cre] (ORCID:


Documentation:   PDF Manual  


AGPL-3 license


Imports R6, chk, DBI

Suggests roxygen2, testthat, knitr, rmarkdown, covr, cyclocomp, lintr, lgr, RSQLite


See at CRAN