ggsql

Grammar of Graphics for SQL

v0.3.3 · Jun 3, 2026 · MIT + file LICENSE

Description

Allows you to write queries that combine SQL (Structured Query Language) data retrieval with visualization specifications in a single, composable syntax. The 'ggsql' package binds directly with the 'ggsql' 'Rust' library and allows you to set up readers and writers and execute queries against it. The package also offers 'knitr' and 'shiny' integration allowing the user to use 'ggsql' in both frameworks.

Downloads

CRAN

675

Last 30 days

4721st

817

Last 90 days

817

Last year

Trend: +375.4% (30d vs prior 30d)

r2u CRAN

Last 30 days

Last 90 days

Last year

CRAN Check Status

13 OK

Show all 13 flavors

Flavor	Status	Time
r-devel-linux-x86_64-debian-clang	OK	4054.2s
r-devel-linux-x86_64-debian-gcc	OK	2955.2s
r-devel-linux-x86_64-fedora-clang	OK	6956.8s
r-devel-linux-x86_64-fedora-gcc	OK	7370.9s
r-devel-windows-x86_64	OK	3249s
r-oldrel-macos-arm64	OK	254s
r-oldrel-macos-x86_64	OK	1342s
r-oldrel-windows-x86_64	OK	4194s
r-patched-linux-x86_64	OK	3526.8s
r-release-linux-x86_64	OK
r-release-macos-arm64	OK	229s
r-release-macos-x86_64	OK	927s
r-release-windows-x86_64	OK	3399s

Check History

OK 13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Jun 11, 2026

ERROR 3 OK · 0 NOTE · 0 WARNING · 4 ERROR · 0 FAILURE May 28, 2026

ERROR r-release-macos-arm64

whether package can be installed

Installation failed.
See ‘/Volumes/Builds/packages/sonoma-arm64/results/4.6/ggsql.Rcheck/00install.out’ for details.

ERROR r-release-macos-x86_64

whether package can be installed

Installation failed.
See ‘/Volumes/Builds/packages/big-sur-x86_64/results/4.6/ggsql.Rcheck/00install.out’ for details.

ERROR r-oldrel-macos-arm64

whether package can be installed

Installation failed.
See ‘/Volumes/Builds/packages/big-sur-arm64/results/4.5/ggsql.Rcheck/00install.out’ for details.

ERROR r-oldrel-macos-x86_64

whether package can be installed

Installation failed.
See ‘/Volumes/Builds/packages/big-sur-x86_64/results/4.5/ggsql.Rcheck/00install.out’ for details.

Reverse Dependencies (1)

suggests

querychat

Dependency Network

Version History

2 tracked

updated 0.3.3 ← 0.3.2 diff Jun 3, 2026

new 0.3.2 May 27, 2026