Skip to content

sqlq

'SQL' Query Builder

v1.0.1 · Sep 16, 2025 · AGPL-3

Description

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.

Downloads

CRAN

532

Last 30 days

6748th

1.8K

Last 90 days

5.7K

Last year

Trend: -9.2% (30d vs prior 30d)

r2u CRAN

7

Last 30 days

19

Last 90 days

53

Last year

Trend: -41.7% (30d vs prior 30d)

CRAN Check Status

13 OK
Show all 13 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang OK
r-devel-linux-x86_64-debian-gcc OK
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK

Check History

OK 13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Jun 9, 2026
ERROR 12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Jun 8, 2026
ERROR r-devel-linux-x86_64-debian-gcc

CRAN incoming feasibility

Maintainer: ‘Pierrick Roger <pierrick.roger@cea.fr>’

Reading Rd files failed with message:
  cannot open the connection
NOTE 12 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Jun 7, 2026
NOTE r-devel-linux-x86_64-debian-gcc

dependencies in R code

Fatal error: cannot create 'R_TempDir'
OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026

Dependency Network

Dependencies Reverse dependencies R6 chk DBI sqlq

Version History

1 tracked
new 1.0.1 Mar 10, 2026

R Observatory began tracking this package on Mar 10, 2026; it first appeared on CRAN Sep 16, 2025. Releases before tracking aren’t shown.