sqlq-package: sqlq: 'SQL' Query Builder

In sqlq: 'SQL' Query Builder

sqlq: 'SQL' Query Builder

Description

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.

Details

sqlq package.

sqlq simplifies the creation of SQL queries, and ensure identifiers and string values are correctly quoted.

Global options used by sqlq:

• sqlq_always_quote: If set to TRUE, token identifiers (table and column names) will always be quoted.

• sqlq_conn: Set the database connector to use for quoting identifiers and values. Default is DBI::ANSI().

• sqlq_omit_kwd: If set to TRUE, optional SQL keywords (like INNER or OUTER) will be omitted.

• sqlq_spaces: If set to FALSE, try to avoid non-necessary spaces (e.g.: around operators or after a comma).

• sqlq_uppercase: If set to FALSE, SQL keywords and alphabetical operators (e.g.: OR, AND, ...) will be written in lowercase.

Author(s)

Maintainer: Pierrick Roger [e-mail] (ORCID)

See Also

options.

Examples

options(sqlq_uppercase = FALSE)

sqlq documentation built on Sept. 16, 2025, 9:10 a.m.