R Observatory: Metrics for sqlq version 1.0.1

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

sqlq

1.0.1

'SQL' Query Builder

0packages depend

6.3Kdownloads / year

98.4%test coverage

13/13checks pass

Overview

About

Maintained by Pierrick RogerFirst published 2025-09-161 releasesCRAN page ↗GitLab ↗

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.

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("sqlq", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("cnrgh/databases")

Development version from cnrgh/databases. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-sqlq

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-sqlq

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-sqlq

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

13OK

Slowest check: 2.6 min · r-oldrel-windows-x86_64

Code health

Yes

Tests · ratio 0.32

98.4%

Coverage · measured lines

100%

Documentation · exports

3

Dependencies · direct

Check history

OK2026-08-04
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
NOTE2026-08-01
12 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-06-09
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-06-08
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
NOTE2026-06-07
12 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Show 1 earlier snapshots

OK2026-03-10
14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMENoVignettesYes · dynamicpkgdown siteNoNEWSNoCode of conductNoContributing guideNo

Examples that run: 100%
Documented parameters: 100%
Return-value docs: 30%
References docs: 0%

Downloads

6.3K

CRAN downloads in the past year

Rank #7,391 · ~17/day · ~522/mo

Releases R versions

Daily download trend is not available in this view yet.

26830 days

1.2K90 days

6.3K1 year

Compare downloads with other packages →

Also on65 r2u19 autocran178 conda_forge

Repository

GitLab ↗ cnrgh/databases

Repository practices

Upstream repositoryBeta

Repository gitlab.com/cnrgh/databases/r-sqlq is linked, but repository-practices checks have not run for it yet. Checks are GitHub-only for now.

How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies

12 external dependencies (excludes base and recommended)

Depends (1)

R >= 4.1

Imports (3)

R6 chk DBI

LinkingTo (0)

none

Suggests (9)

roxygen2 testthat knitr rmarkdown covr cyclocomp lintr lgr RSQLite

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

People & History

People (1)

Maintainer (1)

Pierrick Roger

Author, Maintainer

Authors (1)

Pierrick Roger

Author, Maintainer

Package Timeline

1 release. R releases are shown for context.

R
R 4.6.0 released · 2026-04-24
1.0.1Latest
2026-03-10 · current release
R
R 4.5.0 released · 2025-04-11

Package metadata

First published: 2025-09-16
Total releases: 1 / 1 yrs
License: AGPL-3 OSI
Minimum R: ≥ 4.1
Download size: 56 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("sqlq")

Format

Roger, P. (2025). sqlq: 'SQL' Query Builder (Version 1.0.1) [Computer software]. https://doi.org/10.32614/CRAN.package.sqlq

This is what citation() produces when a package has no citation file of its own. If it prints something else, use that.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for sqlq version 1.0.1 [Data set]. HJJB, LLC. Data release v2026-08-24. https://doi.org/10.5281/zenodo.21843040

From data release v2026-08-24, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →