Learn R Programming

sqlcaser (version 0.2.0)

'SQL' Case Statement Generator

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.

Copy Link

Version

Install

install.packages('sqlcaser')

Monthly Downloads

455

Version

0.2.0

License

MIT + file LICENSE

Maintainer

Leoson Hoay

Last Published

November 24th, 2023

Functions in sqlcaser (0.2.0)

updatetable

Generate a SQL UPDATE statement from a mapping file
casewhen

Generate a SQL CASE statement from a mapping file
inlist

Generate a SQL IN statement from a mapping file