Other packages > Find by keyword >

sqlcaser  

'SQL' Case Statement Generator
View on CRAN: Click here


Download and install sqlcaser package within the R console
Install from CRAN:
install.packages("sqlcaser")

Install from Github:
library("remotes")
install_github("cran/sqlcaser")

Install by package version:
library("remotes")
install_version("sqlcaser", "0.2.1")



Attach the package and use:
library("sqlcaser")
Maintained by
Leoson Hoay
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2023-11-24
Latest Update: 2023-11-24
Description:
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.
How to cite:
Leoson Hoay (2023). sqlcaser: 'SQL' Case Statement Generator. R package version 0.2.1, https://cran.r-project.org/web/packages/sqlcaser. Accessed 10 Oct. 2026.
Previous versions and publish date:
(2026-07-09 07:08), 0.2.0 (2023-11-24 14:20)
Other packages that cited sqlcaser R package
View sqlcaser citation profile
Other R packages that sqlcaser depends, imports, suggests or enhances
Complete documentation for sqlcaser
Functions, R codes and Examples using the sqlcaser R package
Some associated functions: casewhen . inlist . updatetable . 
Some associated R codes: casewhen.R . inlist.R . updatetable.R .  Full sqlcaser package functions and examples
Downloads during the last 30 days

Today's Hot Picks in Authors and Packages

quickcode  
Quick and Essential 'R' Tricks for Better Scripts
The NOT functions, 'R' tricks and a compilation of some simple quick plus often used 'R' codes to im ...
Download / Learn more Package Citations See dependency  
textplot  
Text Plots
Visualise complex relations in texts. This is done by providing functionalities for displaying text ...
Download / Learn more Package Citations See dependency  
TrendTM  
Trend of High-Dimensional Time Series Matrix Estimation
Matrix factorization for multivariate time series with both low rank and temporal structures. The pr ...
Download / Learn more Package Citations See dependency  
MGDrivE  
Mosquito Gene Drive Explorer
Provides a model designed to be a reliable testbed where various gene drive interventions for mosqu ...
Download / Learn more Package Citations See dependency  
landscapeR  
Categorical Landscape Simulation Facility
Simulates categorical maps on actual geographical realms, starting from either empty landscapes or l ...
Download / Learn more Package Citations See dependency  
BRugs  
Interface to the 'OpenBUGS' MCMC Software
Fully-interactive R interface to the 'OpenBUGS' software for Bayesian analysis using MCMC sampling. ...
Download / Learn more Package Citations See dependency  

29,000

R Packages

247,686

Dependencies

76,729

Author Associations

28,990

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA