Registering the engine | The {ggsql} chunk | Chunk options | Defining a backend | Choosing a writer | Communicating with R and Python | Getting data back from ggsql
Package: ggsql 0.5.2.9000
Thomas Lin Pedersen
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.
Authors:
ggsql_0.5.2.9000.tar.gz
ggsql_0.5.2.9000.zip(r-4.7-x86_64)ggsql_0.5.2.9000.zip(r-4.7-arm64)ggsql_0.5.2.9000.zip(r-4.6-x86_64)ggsql_0.5.2.9000.zip(r-4.6-arm64)ggsql_0.5.2.9000.zip(r-4.5-x86_64)
ggsql_0.5.2.9000.tgz(r-4.6-x86_64)ggsql_0.5.2.9000.tgz(r-4.6-arm64)ggsql_0.5.2.9000.tgz(r-4.5-x86_64)ggsql_0.5.2.9000.tgz(r-4.5-arm64)
ggsql_0.5.2.9000.tar.gz(r-4.7-arm64)ggsql_0.5.2.9000.tar.gz(r-4.7-x86_64)ggsql_0.5.2.9000.tar.gz(r-4.6-arm64)ggsql_0.5.2.9000.tar.gz(r-4.6-x86_64)
ggsql_0.5.2.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
ggsql/json (API)
| # Install 'ggsql' in R: |
| install.packages('ggsql', repos = c('https://posit-dev.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/posit-dev/ggsql-r/issues
Pkgdown/docs site:https://r.ggsql.org
Last updated from:631cca7870. Checks:15 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-arm64 | OK | 841 | ||
| linux-devel-x86_64 | OK | 997 | ||
| source / vignettes | OK | 1624 | ||
| linux-release-arm64 | OK | 879 | ||
| linux-release-x86_64 | OK | 1162 | ||
| macos-release-arm64 | OK | 1092 | ||
| macos-release-x86_64 | OK | 2680 | ||
| macos-oldrel-arm64 | OK | 1102 | ||
| macos-oldrel-x86_64 | OK | 1364 | ||
| windows-devel-arm64 | OK | 1383 | ||
| windows-devel-x86_64 | OK | 1995 | ||
| windows-release-arm64 | OK | 1147 | ||
| windows-release-x86_64 | OK | 1848 | ||
| windows-oldrel-x86_64 | OK | 1898 | ||
| wasm-release | OK | 1045 |
Exports:custom_readerduckdb_readerggsql_executeggsql_execute_sqlggsql_has_visualggsql_is_validggsql_layer_countggsql_layer_dataggsql_layer_sqlggsql_metadataggsql_registerggsql_renderggsql_saveggsql_session_readerggsql_sqlggsql_stat_dataggsql_stat_sqlggsql_tableggsql_table_namesggsql_unregisterggsql_validateggsql_visualggsql_warningsggsql_widgetggsqlOutputhep_writerodbc_readerpdf_writerrenderGgsqlsnowflake_readersvg_writervegalite_writer
Dependencies:base64encbslibcachemclidigestevaluatefastmapfontawesomefshighrhtmltoolshtmlwidgetsjquerylibjsonliteknitrlifecyclememoisemimenanoarrowR6rappdirsrlangrmarkdownsasstinytexxfunyaml
The ggsql knitr engine
Last update: 2026-04-30
Started: 2026-04-17
Getting started
Package anatomy | Creating a reader | Executing a query | Rendering a plot
Last update: 2026-04-21
Started: 2026-04-17
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Create a reader backed by R callbacks | custom_reader |
| Create a DuckDB reader | duckdb_reader |
| Execute a ggsql query | ggsql_execute ggsql_execute_sql |
| Register and unregisters a data frame as a queryable table | ggsql_register ggsql_table ggsql_table_names ggsql_unregister |
| Render a spec with a writer | ggsql_render |
| Save a ggsql spec to a file | ggsql_save |
| Set the ggsql reader for the current Shiny session | ggsql_session_reader |
| Validate a ggsql query | ggsql_has_visual ggsql_is_valid ggsql_validate |
| Create a ggsql htmlwidget | ggsql_widget |
| Shiny bindings for ggsql | ggsqlOutput renderGgsql |
| Create an ODBC reader | odbc_reader |
| Create a Snowflake reader | snowflake_reader |
| Utility functions for visualization specifications | ggsql_layer_count ggsql_layer_data ggsql_layer_sql ggsql_metadata ggsql_sql ggsql_stat_data ggsql_stat_sql ggsql_visual ggsql_warnings spec_utility |
| Create a writer for a ggsql spec | hep_writer pdf_writer svg_writer |