ggsql: Grammar of Graphics for SQL
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.
| Version: | 0.3.2 |
| Depends: | R (≥ 4.2) |
| Imports: | cli, htmltools, htmlwidgets, jsonlite, knitr, nanoarrow, R6, rlang (≥ 1.1.0), yaml |
| Suggests: | gapminder, quarto, reticulate, rmarkdown, rsvg, shiny, testthat (≥ 3.0.0), V8, withr |
| Published: | 2026-05-27 |
| DOI: | 10.32614/CRAN.package.ggsql (may not be active yet) |
| Author: | Thomas Lin Pedersen
 [aut, cre],
George Stagg
[aut],
Teun van den Brand
[aut],
Posit, PBC  [cph, fnd] |
| Maintainer: | Thomas Lin Pedersen <thomas.pedersen at posit.co> |
| BugReports: | https://github.com/posit-dev/ggsql-r/issues |
| License: | MIT + file LICENSE |
| URL: | https://r.ggsql.org, https://github.com/posit-dev/ggsql-r |
| NeedsCompilation: | yes |
| SystemRequirements: | Cargo (Rust's package manager), rustc, ODBC driver manager (unixODBC on Linux, iODBC or unixODBC on macOS; built into Windows) |
| Materials: | README, NEWS |
| CRAN checks: | ggsql results |
Documentation:
| Reference manual: | ggsql.html , ggsql.pdf |
| Vignettes: |
The ggsql knitr engine (source, R code) Getting started (source, R code) |
Downloads:
| Package source: | ggsql_0.3.2.tar.gz |
| Windows binaries: | r-devel: not available, r-release: not available, r-oldrel: not available |
| macOS binaries: | r-release (arm64): not available, r-oldrel (arm64): not available, r-release (x86_64): not available, r-oldrel (x86_64): not available |
Linking:
Please use the canonical form https://CRAN.R-project.org/package=ggsql to link to this page.