SQLove

1.0.2

Execute 'SQL' Scripts in 'R' Containing Multiple Queries

0packages depend

6.1Kdownloads / year

–test coverage

11/13checks pass

Overview

About

Maintained by Kerns SamFirst published 2023-02-166 releasesCRAN page ↗

The nature of working with structured query language ('SQL') scripts efficiently often requires the creation of temporary tables and there are few clean and simple 'R' 'SQL' execution approaches that allow you to complete this kind of work with the 'R' environment. This package seeks to give 'SQL' implementations in 'R' a little love by deploying functions that allow you to deploy complex 'SQL' scripts within a typical 'R' workflow.

Install

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

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

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

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

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

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

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

Health

CRAN checks

2NOTE11OK

Failing flavors

NOTE r-devel-linux-x86_64-fedora-clang
NOTE r-devel-linux-x86_64-fedora-gcc

Slowest check: 58 s · r-oldrel-windows-x86_64

Code health

None

Tests · ratio 0.00

not tracked

Coverage

100%

Documentation · exports

Dependencies · direct

Check history

NOTE2026-06-09
11 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-06-08
10 OK · 2 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
NOTE2026-04-06
12 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-04-04
11 OK · 2 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
NOTE2026-03-10
12 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 25 wordsVignettesYes · dynamicpkgdown siteNoNEWSYes · 67% structuredCode of conductNoContributing guideNo

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

Downloads

6.1K

CRAN downloads in the past year

Rank #7,123 · ~17/day · ~512/mo

Releases R versions

Daily download trend is not available in this view yet.

27630 days

1.4K90 days

6.1K1 year

Compare downloads with other packages →

Also on82 r2u

Dependencies

Declared dependencies

6 external dependencies (excludes base and recommended)

Depends (0)

none

Imports (4)

DBI readr RJDBC odbc

LinkingTo (0)

none

Suggests (2)

knitr rmarkdown

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

People & History

People (1)

Maintainer (1)

Kerns Sam

Author, Maintainer

Authors (1)

Kerns Sam

Author, Maintainer

Package Timeline

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

R
R 4.6.0 released · 2026-04-24
1.0.2Latest
2025-04-17 · current release · diff ↗
R
R 4.5.0 released · 2025-04-11
1.0.1
2025-04-10 · diff ↗
R
R 4.4.0 released · 2024-04-24
0.0.4
2023-11-13 · diff ↗
0.0.3
2023-11-10 · diff ↗
R
R 4.3.0 released · 2023-04-21
0.0.2
2023-03-06 · diff ↗
0.0.1
2023-02-16
R
R 4.2.0 released · 2022-04-22

Package metadata

First published: 2023-02-16
Total releases: 6 / 3 yrs
License: MIT + file LICENSE OSI
Download size: 13 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Report a problem with this page →