Bindings to ggsql — Grammar of Graphics based visualizations in SQL
Maintainer(s):
thomasp85
Installing and Loading
INSTALL ggsql FROM community;
LOAD ggsql;
Example
SELECT 1 AS x, 2 AS y VISUALISE x, y DRAW point;
About ggsql
ggsql extends DuckDB's SQL with the visual query language defined by ggsql
(https://ggsql.org) to allow direct visualization from DuckDB. Results are
served from an in-process HTTP server and opened in the default browser.
The session setting ggsql_output switches to returning a URL, the raw
vega-lite spec, or a self-contained HTML document instead.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| ggsql | scalar | NULL | NULL |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
| name | description | input_type | scope | aliases |
|---|---|---|---|---|
| ggsql_output | Output mode for ggsql queries. 'silent' (default) opens the browser and emits no rows; 'url' opens the browser and returns the plot URL; 'spec' returns the vega-lite JSON; 'html' returns a self-contained HTML document. | VARCHAR | GLOBAL | [] |