The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

sqlcaser: 'SQL' Case Statement Generator

Includes built-in methods for generating long 'SQL' CASE statements, and other 'SQL' statements that may otherwise be arduous to construct by hand. The generated statement can easily be concatenated to string literals to form queries to 'SQL'-like databases, such as when using the 'RODBC' package. The current methods include casewhen() for building CASE statements, inlist() for building IN statements, and updatetable() for building UPDATE statements.

Version: 0.2.0
Suggests: knitr, rmarkdown
Published: 2023-11-24
DOI: 10.32614/CRAN.package.sqlcaser
Author: Leoson Hoay ORCID iD [aut, cre]
Maintainer: Leoson Hoay <leoson.public at gmail.com>
License: MIT + file LICENSE
NeedsCompilation: no
Materials: NEWS
CRAN checks: sqlcaser results

Documentation:

Reference manual: sqlcaser.pdf
Vignettes: sqlcaseR: Building long CASE WHEN statements for SQL interfaces in R

Downloads:

Package source: sqlcaser_0.2.0.tar.gz
Windows binaries: r-devel: sqlcaser_0.2.0.zip, r-release: sqlcaser_0.2.0.zip, r-oldrel: sqlcaser_0.2.0.zip
macOS binaries: r-release (arm64): sqlcaser_0.2.0.tgz, r-oldrel (arm64): sqlcaser_0.2.0.tgz, r-release (x86_64): sqlcaser_0.2.0.tgz, r-oldrel (x86_64): sqlcaser_0.2.0.tgz

Linking:

Please use the canonical form https://CRAN.R-project.org/package=sqlcaser to link to this page.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.