[R-pkgs] New package lazysql: Lazy SQL Programming
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
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
Bug reports, suggestions, and feature requests are highly appreciated
More information about the R-packages