Package: sqlcaser 0.2.0

Leoson Hoay

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.

Authors:Leoson Hoay [aut, cre]

sqlcaser_0.2.0.tar.gz
sqlcaser_0.2.0.tar.gz(r-4.5-noble)sqlcaser_0.2.0.tar.gz(r-4.4-noble)
sqlcaser_0.2.0.tgz(r-4.4-emscripten)sqlcaser_0.2.0.tgz(r-4.3-emscripten)
sqlcaser.pdf |sqlcaser.html✨
sqlcaser/json (API)
NEWS

# Install 'sqlcaser' in R:
install.packages('sqlcaser', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org'))

On CRAN:

Conda:

This package does not link to any Github/Gitlab/R-forge repository. No issue tracker or development information is available.

2.00 score 149 downloads 3 exports 0 dependencies

Last updated 1 years agofrom:471231d997. Checks:2 OK. Indexed: yes.

TargetResultLatest binary
Doc / VignettesOKFeb 28 2025
R-4.5-linuxOKFeb 28 2025

Exports:casewheninlistupdatetable

Dependencies:

sqlcaseR: Building long CASE WHEN statements for SQL interfaces in R

Rendered fromintroduction.Rmdusingknitr::rmarkdownon Feb 28 2025.

Last update: 2023-11-25
Started: 2023-11-25