[R-pkgs] New package lazysql: Lazy SQL Programming

Uwe Block u.block.mz at gmail.com
Sat Mar 12 17:11:16 CET 2016


Dear R users,

The new package lazysql has been accepted on CRAN
(https://cran.r-project.org/web/packages/lazysql/).

It includes helper functions to build SQL statements under program
control for use with dbGetQuery or dbSendQuery. They are intended to
increase speed of coding and to reduce coding errors. Arguments are
carefully checked, in particular SQL identifiers such as names of
tables or columns.

Currently implemented are:

- date_between: Create SQL string to select date between two given dates.
- in_condition: Create SQL string to select values included (or not
included) in a set of given values.
- natural_key: Create SQL string for joining on matching natural keys.

More patterns will be added as required.

Examples of usage  can be found at
https://github.com/UweBlock/lazysql/blob/master/README.md.

Bug reports, suggestions, and feature requests are highly appreciated
at https://github.com/UweBlock/lazysql/issues.

Have fun,
Uwe



More information about the R-packages mailing list