sqlcaser

From MaRDI portal
Software:5979696



CRANsqlcaserMaRDI QIDQ5979696

'SQL' Case Statement Generator

Could not fetch data.

Last update: 24 November 2023

Copyright license: Could not fetch data.

Software version identifier: 0.2.0



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.