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 [aut, cre] |
Maintainer: | Leoson Hoay <leoson.public at gmail.com> |
License: | MIT + file LICENSE |
NeedsCompilation: | no |
Materials: | NEWS |
CRAN checks: | sqlcaser results |
Reference manual: | sqlcaser.pdf |
Vignettes: |
sqlcaseR: Building long CASE WHEN statements for SQL interfaces in R |
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 |
Please use the canonical form https://CRAN.R-project.org/package=sqlcaser to link to this page.