R Observatory: Metrics for SQLFormatteR version 0.0.2

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

CRAN requires the check problems on this package to be fixed before 2026-09-04 or it will be archived.

SQLFormatteR

0.0.2

Format SQL Queries

0packages depend

2.3Kdownloads / year

–test coverage

3/13checks pass

Overview

About

Maintained by Morgan DurandFirst published 2025-02-042 releasesCRAN page ↗GitHub ↗

A convenient interface for formatting 'SQL' queries directly within 'R'. It acts as a wrapper around the 'sql_format' Rust crate. The package allows you to format 'SQL' code with customizable options, including indentation, case formatting, and more, ensuring your 'SQL' queries are clean, readable, and consistent.

Install

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

install.packages("SQLFormatteR", 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("dataupsurge/SQLFormatteR")

Development version from dataupsurge/SQLFormatteR. 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-sqlformatter

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-SQLFormatteR

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

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

Health

CRAN checks

10NOTE3OK

Failing flavors

NOTE r-devel-linux-x86_64-debian-clang
NOTE r-devel-linux-x86_64-debian-gcc
NOTE r-devel-linux-x86_64-fedora-clang
NOTE r-devel-linux-x86_64-fedora-gcc
NOTE r-devel-windows-x86_64
NOTE r-patched-linux-x86_64
NOTE r-release-linux-x86_64
NOTE r-release-macos-arm64
NOTE r-release-macos-x86_64
NOTE r-release-windows-x86_64

Slowest check: 3.4 min · r-devel-windows-x86_64

Code health

Yes

Tests · ratio 0.30

not tracked

Coverage

100%

Documentation · exports

1

Dependencies · direct

Check history

NOTE2026-03-28
13 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-03-10
14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 169 wordsVignettesNopkgdown siteNoNEWSYes · 100% structuredCode of conductNoContributing guideNo

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

Downloads

2.3K

CRAN downloads in the past year

Rank #16,812 · ~6/day · ~191/mo

Releases R versions

Daily download trend is not available in this view yet.

19130 days

65590 days

2.3K1 year

Compare downloads with other packages →

Also on400 r2u

Repository

GitHub ↗ dataupsurge/sqlformatter

8Stars

1Forks

0Open issues

0Open PRs

2Releases

11Commits

3Contributors

11 commits · Last activity 2025-04-14 · 0% stars, 30d

Stars over time

2025-05-10 · 62026-07-07 · 8

Repository practices

Upstream repositoryBeta

5 development-tooling and community-health practices detected across 5 families in the upstream repository

Checks run against github.com/dataupsurge/sqlformatter on 2026-08-23.

Continuous integration (1)

GitHub Actions

Reproducibility and dev environment (1)

renv

CRAN release process (1)

cran-comments.md

Automation and maintenance (1)

pre-commit

Show all practices

Lint, format, editor (1)

lintr

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

Dependencies

Declared dependencies

12 external dependencies (excludes base and recommended)

Depends (1)

R >= 4.2

Imports (1)

assertthat

LinkingTo (0)

none

Suggests (11)

covr docopt git2r jsonlite lintr optparse precommit rextendr roxygen2 styler testthat

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

People & History

People (2)

Maintainer (1)

Morgan Durand

Author, Maintainer, Copyright holder

Authors (2)

Morgan Durand

Author, Maintainer, Copyright holder

Authors of the dependent Rust crates

Author

Copyright holders (1)

Morgan Durand

Author, Maintainer, Copyright holder

Package Timeline

2 releases. Pick two to compare their code metrics. R releases are shown for context.

R
R 4.6.0 released · 2026-04-24
0.0.2Latest
2025-04-13 · current release · diff ↗
R
R 4.5.0 released · 2025-04-11
0.0.1
2025-02-04
R
R 4.4.0 released · 2024-04-24

Package metadata

First published: 2025-02-04
Total releases: 2 / 1 yrs
License: MIT + file LICENSE OSI
Minimum R: ≥ 4.2
Download size: 810 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("SQLFormatteR")

Format

Durand, M., & Authors of the dependent Rust crates. (2025). SQLFormatteR: Format SQL Queries (Version 0.0.2) [Computer software]. https://doi.org/10.32614/CRAN.package.SQLFormatteR

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 SQLFormatteR version 0.0.2 [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 →