R Observatory: Metrics for sqlq version 1.0.1

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

sqlq

1.0.1Package record

'SQL' Query Builder

0packages depend

6.4Kdownloads / year

98.4%test coverage

13/13flavors OK

Overview

About

Maintained by Pierrick RogerCRAN page ↗GitLab ↗Issues ↗

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. We list this channel from recorded r2u download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

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). We list this channel from recorded autoCRAN download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

Health

CRAN checks

13OK

CRAN check page ↗

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

Status changes

OK13 OK2026-08-04
NOTE12 OK, 1 NOTE2026-08-01
OK13 OK2026-06-09
ERROR12 OK, 1 ERROR2026-06-08
NOTE12 OK, 1 NOTE2026-06-07

Show 1 earlier changeHide 1 earlier change

OK14 OK2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 1.0.1

READMENoVignettesYes · 1 · dynamicNEWSNoCitation fileNoWebsitenot declared in DESCRIPTION

Help pages: 58includes a package overview page
Examples that run: 78%43 run in a plain check · 12 hold no code
Exported functions with examples: 100%
Documented parameters: 100%
Return-value docs: 30%
Help pages citing references: 0%

Vignettes (1)

Introduction to sqlq package HTML

How these are measured

Downloads

6.4K

CRAN downloads in the past year

Rank #9,108 · ~18/day · ~535/mo

Releases R versions

Daily download trend is not available in this view yet.

38630 days

1K90 days

6.4K1 year

Compare downloads with other packages →

Also on65 r2u3 autocran237 conda_forge

How downloads are counted

Repository

gitlab.com/cnrgh/databases/r-sqlq ↗

0Stars

0Forks

1Open issues

0Open PRs

0Releases

Last activity 2025-09-11

Responsiveness

How these are sampled

PRs merged (all time): 97%
Median days to close, 50 most recently updated closed issues: not measured
Median days to close, 50 most recently updated closed PRs: not measured

How these are measured

PracticesBeta

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 v3 (2026-09-26)

Dependencies

Declared dependencies

12 external dependencies (excludes base and recommended)

Installing sqlq adds 6 packages (2 with compiled code, 2.9 MB of source tarballs). Heaviest: rlang 766 KB, DBI 727 KB, chk 687 KB.

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.

How these are counted

Code & Tests

People & History

People (1)

Pierrick Roger

Author, Maintainer since 1.0.1 (2025)

Releases (1)

R
R 4.6.0 released · 2026-04-24
1.0.1Latest
record
2025-09-16 · 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

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 package has no citation file, so citation() returns this entry built from DESCRIPTION.

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-10-19. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-19, 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 →