Package: sqlq 1.0.1

Pierrick Roger

sqlq: 'SQL' Query Builder

Allows to build complex 'SQL' (Structured Query Language) queries dynamically. Classes and/or factory functions are used to produce a syntax tree from which the final character string is generated. Strings and identifiers are automatically quoted using the right quotes, using either ANSI (American National Standards Institute) quoting or the quoting style of an existing database connector. Style can be configured to set uppercase/lowercase for keywords, remove unnecessary spaces, or omit optional keywords.

Authors:Pierrick Roger [aut, cre]

sqlq_1.0.1.tar.gz
sqlq_1.0.1.zip(r-4.7-any)sqlq_1.0.1.zip(r-4.6-any)sqlq_1.0.1.zip(r-4.5-any)
sqlq_1.0.1.tgz(r-4.6-any)sqlq_1.0.1.tgz(r-4.5-any)
sqlq_1.0.1.tar.gz(r-4.7-any)sqlq_1.0.1.tar.gz(r-4.6-any)
sqlq_1.0.1.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION
card.svg |card.png
sqlq/json (API)

# Install 'sqlq' in R:
install.packages('sqlq', repos = c('https://cnrgh.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://gitlab.com/cnrgh/databases

On CRAN:

Conda:

3.18 score 1 packages 421 downloads 60 exports 6 dependencies

Last updated from:2ec97c82d6. Checks:7 WARNING, 1 ERROR, 1 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-develWARNING156
source / vignettesERROR254
linux-releaseWARNING141
macos-releaseWARNING178
macos-oldrelWARNING196
windows-develWARNING78
windows-releaseWARNING93
windows-oldrelWARNING81
wasm-releaseOK115

Exports:apply_caseExprExprBetweenExprBinOpExprCommOpExprCompExprFieldExprFieldDefExprIsNotNullExprIsNullExprListExprListFieldsExprListValuesExprUnaryOpExprValuemake_betweenmake_create_tablemake_deletemake_fieldsmake_insertmake_joinmake_left_opmake_middle_opmake_rowmake_rowsmake_selectmake_select_allmake_setmake_updatemake_valuesmake_whereoptspaceQueryQueryCreateQueryDeleteQueryInsertQuerySelectQueryUpdatequote_idsquote_valuesStatementStmtCreateStmtDeleteStmtFromStmtInsertStmtJoinStmtLimitStmtSelectStmtSelectAllStmtSelectFieldsStmtSetStmtUpdateStmtValuesStmtWhereTokenTokenEmptyTokenIdentifierTokenKeywordTokenSymbolTokenValue

Dependencies:chkcliDBIlifecycleR6rlang