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 _______________________________________________ R-packages mailing list r-packa...@r-project.org https://stat.ethz.ch/mailman/listinfo/r-packages ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
