Skip to content

SQLove

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

v1.0.2 · Apr 16, 2025 · MIT + file LICENSE

Description

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.

Downloads

606

Last 30 days

6128th

606

Last 90 days

606

Last year

CRAN Check Status

1 ERROR
2 NOTE
11 OK
Show all 14 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang ERROR
r-devel-linux-x86_64-debian-gcc OK
r-devel-linux-x86_64-fedora-clang NOTE
r-devel-linux-x86_64-fedora-gcc NOTE
r-devel-macos-arm64 OK
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK
Check details (14 non-OK)
ERROR r-devel-linux-x86_64-debian-clang

package dependencies

Package required but not available: ‘RJDBC’

See section ‘The DESCRIPTION file’ in the ‘Writing R Extensions’
manual.
OK r-devel-linux-x86_64-debian-gcc

*


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

dependencies in R code

Namespace in Imports field not imported from: ‘odbc’
  All declared Imports should be used.
NOTE r-devel-linux-x86_64-fedora-gcc

dependencies in R code

Namespace in Imports field not imported from: ‘odbc’
  All declared Imports should be used.
OK r-devel-macos-arm64

*


            
OK r-devel-windows-x86_64

*


            
OK r-oldrel-macos-arm64

*


            
OK r-oldrel-macos-x86_64

*


            
OK r-oldrel-windows-x86_64

*


            
OK r-patched-linux-x86_64

*


            
OK r-release-linux-x86_64

*


            
OK r-release-macos-arm64

*


            
OK r-release-macos-x86_64

*


            
OK r-release-windows-x86_64

*


            

Check History

ERROR 11 OK · 2 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Mar 9, 2026
ERROR r-devel-linux-x86_64-debian-clang

package dependencies

Package required but not available: ‘RJDBC’

See section ‘The DESCRIPTION file’ in the ‘Writing R Extensions’
manual.
NOTE r-devel-linux-x86_64-fedora-clang

dependencies in R code

Namespace in Imports field not imported from: ‘odbc’
  All declared Imports should be used.
NOTE r-devel-linux-x86_64-fedora-gcc

dependencies in R code

Namespace in Imports field not imported from: ‘odbc’
  All declared Imports should be used.

Dependency Network

Dependencies Reverse dependencies DBI readr RJDBC odbc SQLove

Version History

new 1.0.2 Mar 9, 2026