sqltargets

0.3.0

'Targets' Extension for 'SQL' Queries

0packages depend

2.5Kdownloads / year

77.4%test coverage

13/13checks pass

Overview

About

Maintained by David RanzolinFirst published 2024-04-245 releasesCRAN page ↗GitHub ↗

Provides an extension for 'SQL' queries as separate file within 'targets' pipelines. The shorthand creates two targets, the query file and the query result.

Install

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

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

Development version from daranzolin/sqltargets. 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-sqltargets

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

# 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-sqltargets

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

Health

CRAN checks

13OK

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

Code health

Yes

Tests · ratio 0.50

77.4%

Coverage · measured lines

100%

Documentation · exports

Dependencies · direct

Check history

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
OK2026-03-10
14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

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

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

Downloads

2.5K

CRAN downloads in the past year

Rank #19,871 · ~7/day · ~211/mo

Releases R versions

Daily download trend is not available in this view yet.

16730 days

58590 days

2.5K1 year

Compare downloads with other packages →

Also on110 r2u28 autocran

Repository

GitHub ↗ daranzolin/sqltargets

41Stars

3Forks

8Open issues

1Open PRs

5Releases

58Commits

3Contributors

pipelinerrstatssqltargetsworkflow

58 commits · Last activity 2025-11-12 · 0% stars, 30d

Stars over time

2025-06-12 · 402026-07-07 · 41

Repository practices

Upstream repositoryBeta

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

Checks run against github.com/daranzolin/sqltargets on 2026-07-19.

Continuous integration (1)

GitHub Actions

CRAN release process (1)

cran-comments.md

Docs source (1)

README.Rmd

Lint, format, editor (1)

RStudio project

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

Dependencies

Declared dependencies

14 external dependencies (excludes base and recommended)

Depends (0)

none

Imports (12)

cli DBI fs glue jinjar purrr readr rlang stringr tarchetypes targets withr

LinkingTo (0)

none

Suggests (2)

testthat RSQLite

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

People & History

People (2)

Maintainer (1)

David Ranzolin

Author, Maintainer, Copyright holder

Authors (1)

David Ranzolin

Author, Maintainer, Copyright holder

Contributors (1)

Roy Storey

Contributor · added in 0.3.0

David Ranzolin

Author, Maintainer, Copyright holder

Package Timeline

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

R
R 4.6.0 released · 2026-04-24
0.3.0Latest
2025-11-10 · current release · diff ↗
R
R 4.5.0 released · 2025-04-11
0.2.1
2024-10-02 · diff ↗
0.2.0
2024-07-31 · diff ↗
0.1.0
2024-06-20 · diff ↗
0.0.1
2024-04-24
R
R 4.4.0 released · 2024-04-24
R
R 4.3.0 released · 2023-04-21

Package metadata

First published: 2024-04-24
Total releases: 5 / 2 yrs
License: MIT + file LICENSE OSI
Download size: 114 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Report a problem with this page →