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.

Package details

AuthorLeoson Hoay [aut, cre] (<https://orcid.org/0000-0003-2079-5579>)
MaintainerLeoson Hoay <leoson.public@gmail.com>
LicenseMIT + file LICENSE
Version0.2.0
Package repositoryView on CRAN
Installation Install the latest version of this package by entering the following in R:
install.packages("sqlcaser")

Try the sqlcaser package in your browser

Any scripts or data that you put into this service are public.

sqlcaser documentation built on Nov. 24, 2023, 5:08 p.m.