lazysql: Lazy SQL Programming

Share:

Helper functions to build SQL statements for dbGetQuery or dbSendQuery under program control. 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. More patterns will be added as required.

Author
Uwe Block [aut, cre]
Date of publication
2016-03-12 06:16:37
Maintainer
Uwe Block <u.block.mz@gmail.com>
License
MIT + file LICENSE
Version
0.1.3
URLs

View on CRAN

Man pages

date_between
Create SQL string to select date between two given dates
in_condition
Create SQL string to select values included in a set of given...
lazysql
Lazy SQL programming
natural_key
Create SQL string for joining on matching natural keys
valid_identifier_regex
Regex pattern to validate SQL identifier names

Files in this package

lazysql
lazysql/tests
lazysql/tests/testthat.R
lazysql/tests/testthat
lazysql/tests/testthat/test_natural_key.R
lazysql/tests/testthat/test_date_between.R
lazysql/tests/testthat/test_in_condition.R
lazysql/NAMESPACE
lazysql/NEWS.md
lazysql/R
lazysql/R/utils.R
lazysql/R/date_between.R
lazysql/R/lazysql-package.R
lazysql/R/in_condition.R
lazysql/R/natural_key.R
lazysql/README.md
lazysql/MD5
lazysql/DESCRIPTION
lazysql/man
lazysql/man/valid_identifier_regex.Rd
lazysql/man/date_between.Rd
lazysql/man/lazysql.Rd
lazysql/man/in_condition.Rd
lazysql/man/natural_key.Rd
lazysql/LICENSE