sqlcaser

From MaRDI portal
(Redirected from Software:5979696)
Sqlcaser



CRANsqlcaserMaRDI QIDQ5979696FDOQ5979696

'SQL' Case Statement Generator

Leoson Hoay

Last update: 24 November 2023

Copyright license: MIT license, File License

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.





This page was built for software: sqlcaser