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:
lazysql_0.1.3.9000.tar.gz
lazysql_0.1.3.9000.zip(r-4.5)lazysql_0.1.3.9000.zip(r-4.4)lazysql_0.1.3.9000.zip(r-4.3)
lazysql_0.1.3.9000.tgz(r-4.4-any)lazysql_0.1.3.9000.tgz(r-4.3-any)
lazysql_0.1.3.9000.tar.gz(r-4.5-noble)lazysql_0.1.3.9000.tar.gz(r-4.4-noble)
lazysql_0.1.3.9000.tgz(r-4.4-emscripten)lazysql_0.1.3.9000.tgz(r-4.3-emscripten)
lazysql.pdf |lazysql.html✨
lazysql/json (API)
NEWS
| # 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
Last updated 9 years agofrom:c6622f65d2. Checks:OK: 3 NOTE: 4. Indexed: yes.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Oct 23 2024 |
| R-4.5-win | OK | Oct 23 2024 |
| R-4.5-linux | OK | Oct 23 2024 |
| R-4.4-win | NOTE | Oct 23 2024 |
| R-4.4-mac | NOTE | Oct 23 2024 |
| R-4.3-win | NOTE | Oct 23 2024 |
| R-4.3-mac | NOTE | Oct 23 2024 |
Exports:date_betweenin_conditionnatural_keyvalid_identifier_regex
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 |
