Package: lazysql 0.1.3.9000

lazysql: Lazy SQL Programming

Helper functions to build SQL statements under program control for dbGetQuery, dbSendQuery, sqldf, etc. 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.

Authors:Uwe Block [aut, cre]

lazysql_0.1.3.9000.tar.gz
lazysql_0.1.3.9000.zip(r-4.7-any)lazysql_0.1.3.9000.zip(r-4.6-any)lazysql_0.1.3.9000.zip(r-4.5-any)
lazysql_0.1.3.9000.tgz(r-4.6-any)lazysql_0.1.3.9000.tgz(r-4.5-any)
lazysql_0.1.3.9000.tar.gz(r-4.7-any)lazysql_0.1.3.9000.tar.gz(r-4.6-any)
lazysql_0.1.3.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
lazysql/json (API)

# Install 'lazysql' in R:

install.packages('lazysql', repos = c('https://uweblock.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/uweblock/lazysql/issues

On CRAN:

3.65 score 9 stars 8 scripts 239 downloads 4 exports 5 dependencies

Last updated from:c6622f65d2. Checks:9 OK. Indexed: yes.

Target	Result	Time
linux-devel	OK	109
source / vignettes	OK	164
linux-release	OK	85
macos-release	OK	138
macos-oldrel	OK	171
windows-devel	OK	54
windows-release	OK	63
windows-oldrel	OK	50
wasm-release	OK	73

Exports:date_between in_condition natural_key valid_identifier_regex

Dependencies:backports checkmate magrittr plyr Rcpp

Citation

Development and contributors

Readme and manuals

Help Manual

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