I am excited beyond description to lift the veil on what we have been working on in 2026:
Please meet ggsql! A new extension of the SQL language for creating visualisations using the grammar of graphics. Read all about it in the blog post or visit the website at ggsql.org
Please meet ggsql! A new extension of the SQL language for creating visualisations using the grammar of graphics. Read all about it in the blog post or visit the website at ggsql.org
ggsql: A grammar of graphics for SQL
Introducing ggsql, a grammar of graphics for SQL that lets you describe visualizations directly inside SQL queries.
opensource.posit.co
April 20, 2026 at 12:38 PM
I am excited beyond description to lift the veil on what we have been working on in 2026:
Please meet ggsql! A new extension of the SQL language for creating visualisations using the grammar of graphics. Read all about it in the blog post or visit the website at ggsql.org
Please meet ggsql! A new extension of the SQL language for creating visualisations using the grammar of graphics. Read all about it in the blog post or visit the website at ggsql.org
As announced at posit::conf(2026) #ggsql is now, with the release of version 0.5.0, in Beta. I'm so excited for the future of this project.
Read all about what the latest version brings you in the release post
Read all about what the latest version brings you in the release post
ggsql 0.5.0: Readers, Writers, and Beta status
Announcing ggsql 0.5.0, with new readers and writers for getting data in and out, and the project's graduation to beta status.
opensource.posit.co
September 24, 2026 at 7:36 AM
As announced at posit::conf(2026) #ggsql is now, with the release of version 0.5.0, in Beta. I'm so excited for the future of this project.
Read all about what the latest version brings you in the release post
Read all about what the latest version brings you in the release post
Do you love maps? Of course you do!
With the latest release of #ggsql we now support spatial plotting directly from your database.
As a cherry on top, the release also provides powerful in-layer aggregation.
Read all about it on the blog
With the latest release of #ggsql we now support spatial plotting directly from your database.
As a cherry on top, the release also provides powerful in-layer aggregation.
Read all about it on the blog
ggsql 0.4.1: Spatial plotting and in-layer aggregation
ggsql 0.4.1 adds support for spatial plotting and data aggregation within layers. Read all about the new features in this release post.
opensource.posit.co
June 23, 2026 at 8:07 AM
Do you love maps? Of course you do!
With the latest release of #ggsql we now support spatial plotting directly from your database.
As a cherry on top, the release also provides powerful in-layer aggregation.
Read all about it on the blog
With the latest release of #ggsql we now support spatial plotting directly from your database.
As a cherry on top, the release also provides powerful in-layer aggregation.
Read all about it on the blog
ggsql 0.5.0, skiLift
October 3, 2026 at 6:37 AM
ggsql 0.5.0, skiLift
ggsql 0.5.0 reaches beta, marking a new maturity phase.
ggsql 0.5.0's beta release signifies its growth since April, featuring enhancements for data visualization via improved text and font rendering. This development underscores its evolving role in AI application…
Read more on Kimbodo:
ggsql 0.5.0's beta release signifies its growth since April, featuring enhancements for data visualization via improved text and font rendering. This development underscores its evolving role in AI application…
Read more on Kimbodo:
AI Application Development — September 24, 2026
Findings [1] 2026-09-24 ggsql 0.5.0: Readers, Writers, and Beta status We are absolutely thrilled to announce the release of ggsql 0.5.0, the first beta release of ggsql since the initial…
kimbodo.com
October 5, 2026 at 4:25 PM
ggsql 0.5.0 reaches beta, marking a new maturity phase.
ggsql 0.5.0's beta release signifies its growth since April, featuring enhancements for data visualization via improved text and font rendering. This development underscores its evolving role in AI application…
Read more on Kimbodo:
ggsql 0.5.0's beta release signifies its growth since April, featuring enhancements for data visualization via improved text and font rendering. This development underscores its evolving role in AI application…
Read more on Kimbodo:
I'm thrilled to share that #querychat now supports more exploratory visualization powered by #ggsql. We're excited about what this direction can unlock for data scientists looking to curate "tidy" data for others explore. Expect more on this in the coming months. opensource.posit.co/blog/2026-06...
Ask more of your dashboard with querychat and ggsql
querychat now supports ggsql-powered visualizations — users can ask "show me" questions and get charts rendered directly in the chat, alongside SQL queries and reactive filtering, all without arbitrar...
opensource.posit.co
June 17, 2026 at 5:53 PM
I'm thrilled to share that #querychat now supports more exploratory visualization powered by #ggsql. We're excited about what this direction can unlock for data scientists looking to curate "tidy" data for others explore. Expect more on this in the coming months. opensource.posit.co/blog/2026-06...
Setting up integration testing for a bunch of backends for ggsql... Druid and Oracle are the last ones defying success and I can see my commit messages becomes more and more poetic as my hope dwindles
October 1, 2026 at 4:46 PM
Setting up integration testing for a bunch of backends for ggsql... Druid and Oracle are the last ones defying success and I can see my commit messages becomes more and more poetic as my hope dwindles
I’ll be presenting our work on #ggsql today at #PositConf2026
It will be lovely and whimsical and I hope you’ll join both if your are new to ggsql or have been following along since the spring
It will be lovely and whimsical and I hope you’ll join both if your are new to ggsql or have been following along since the spring
ggsql
Ggsql.org
September 15, 2026 at 12:04 PM
I’ll be presenting our work on #ggsql today at #PositConf2026
It will be lovely and whimsical and I hope you’ll join both if your are new to ggsql or have been following along since the spring
It will be lovely and whimsical and I hope you’ll join both if your are new to ggsql or have been following along since the spring
Hey @thomasp85.com @teunbrand.bsky.social,
I created a chart builder built on top of #ggsql: plotr.org.
Sort of the ggsql Esquisse version :) Would love to hear what you think! It's still very much experimental though.
I created a chart builder built on top of #ggsql: plotr.org.
Sort of the ggsql Esquisse version :) Would love to hear what you think! It's still very much experimental though.
plotr — A ggsql chart builder
plotr.org
May 20, 2026 at 2:10 PM
Hey @thomasp85.com @teunbrand.bsky.social,
I created a chart builder built on top of #ggsql: plotr.org.
Sort of the ggsql Esquisse version :) Would love to hear what you think! It's still very much experimental though.
I created a chart builder built on top of #ggsql: plotr.org.
Sort of the ggsql Esquisse version :) Would love to hear what you think! It's still very much experimental though.
SQL + ggplot2 = ggsql ❤️
It is hard to find new and exciting open-source projects that aren't related to AI or the agents hype, but this one definitely looks amazing. ggsql is a new open-source project from Posit that implements the grammar of graphics with SQL syntax.
#sql #dataviz #rstats
It is hard to find new and exciting open-source projects that aren't related to AI or the agents hype, but this one definitely looks amazing. ggsql is a new open-source project from Posit that implements the grammar of graphics with SQL syntax.
#sql #dataviz #rstats
April 21, 2026 at 4:03 PM
Ask more of your dashboard with querychat & ggsql! 📊
Explore data in your #RStats and #Python Shiny apps via natural language using safe, reproducible SQL and generate inline charts with ggsql.
🔗 opensource.posit.co/blog/2026-06...
Explore data in your #RStats and #Python Shiny apps via natural language using safe, reproducible SQL and generate inline charts with ggsql.
🔗 opensource.posit.co/blog/2026-06...
Ask more of your dashboard with querychat and ggsql
querychat now supports ggsql-powered visualizations — users can ask "show me" questions and get charts rendered directly in the chat, alongside SQL queries and reactive filtering, all without arbitrar...
opensource.posit.co
July 30, 2026 at 3:43 PM
Ask more of your dashboard with querychat & ggsql! 📊
Explore data in your #RStats and #Python Shiny apps via natural language using safe, reproducible SQL and generate inline charts with ggsql.
🔗 opensource.posit.co/blog/2026-06...
Explore data in your #RStats and #Python Shiny apps via natural language using safe, reproducible SQL and generate inline charts with ggsql.
🔗 opensource.posit.co/blog/2026-06...
My god, I am building some amazing*... Can't wait to tell about it...
*besides ggsql which is also amazing of course
*besides ggsql which is also amazing of course
June 10, 2026 at 5:45 PM
My god, I am building some amazing*... Can't wait to tell about it...
*besides ggsql which is also amazing of course
*besides ggsql which is also amazing of course
New native renderer for #ggsql supporting smooth resizing, rich text layout (not shown), and infrastructure to support interactivity, plot composition and more is coming along nicely
August 18, 2026 at 11:50 AM
New native renderer for #ggsql supporting smooth resizing, rich text layout (not shown), and infrastructure to support interactivity, plot composition and more is coming along nicely
That nice-looking plot might be R, Python, Typst... or even, SQL!?
Join us tomorrow with @thomasp85.com , where he will introduce ggsql, a new package that brings the grammar of graphics (a framework for composing plots) to SQL.
Join the ggparty here: pos.it/dslab
Join us tomorrow with @thomasp85.com , where he will introduce ggsql, a new package that brings the grammar of graphics (a framework for composing plots) to SQL.
Join the ggparty here: pos.it/dslab
June 15, 2026 at 2:35 PM
That nice-looking plot might be R, Python, Typst... or even, SQL!?
Join us tomorrow with @thomasp85.com , where he will introduce ggsql, a new package that brings the grammar of graphics (a framework for composing plots) to SQL.
Join the ggparty here: pos.it/dslab
Join us tomorrow with @thomasp85.com , where he will introduce ggsql, a new package that brings the grammar of graphics (a framework for composing plots) to SQL.
Join the ggparty here: pos.it/dslab
A neat example of #TidyTuesday #dataviz using the hot-off-the-press ggsql, an implementation of the grammar of graphics for SQL! opensource.posit.co/blog/2026-04...
April 28, 2026 at 10:09 PM
A neat example of #TidyTuesday #dataviz using the hot-off-the-press ggsql, an implementation of the grammar of graphics for SQL! opensource.posit.co/blog/2026-04...
Announcing posit::glimpse() May 2026! ✨
Key open-source updates for #RStats, #Python, and now #SQL:
📊 ggsql: Grammar of graphics for SQL
🤖 raghilda: Simplified RAG in Python
🔭 Shiny + pointblank: Built-in OpenTelemetry support
🦀 Quarto 2: A Rust-based future
Read more: posit.co/blog/2026-05...
Key open-source updates for #RStats, #Python, and now #SQL:
📊 ggsql: Grammar of graphics for SQL
🤖 raghilda: Simplified RAG in Python
🔭 Shiny + pointblank: Built-in OpenTelemetry support
🦀 Quarto 2: A Rust-based future
Read more: posit.co/blog/2026-05...
posit::glimpse() Newsletter - May 2026
We’re introducing new packages like ggsql and raghila, alongside major updates to Quarto and many other open-source packages.
posit.co
May 6, 2026 at 2:45 PM
Announcing posit::glimpse() May 2026! ✨
Key open-source updates for #RStats, #Python, and now #SQL:
📊 ggsql: Grammar of graphics for SQL
🤖 raghilda: Simplified RAG in Python
🔭 Shiny + pointblank: Built-in OpenTelemetry support
🦀 Quarto 2: A Rust-based future
Read more: posit.co/blog/2026-05...
Key open-source updates for #RStats, #Python, and now #SQL:
📊 ggsql: Grammar of graphics for SQL
🤖 raghilda: Simplified RAG in Python
🔭 Shiny + pointblank: Built-in OpenTelemetry support
🦀 Quarto 2: A Rust-based future
Read more: posit.co/blog/2026-05...
@thomasp85.com @teunbrand.bsky.social @gws.phd I wrote a little post about why I ggsql makes so much sense to me. Impressive work, congratulations!
carva.lu/posts/i-love...
carva.lu/posts/i-love...
I love ggsql!
Why I think it's great
carva.lu
April 25, 2026 at 1:42 PM
@thomasp85.com @teunbrand.bsky.social @gws.phd I wrote a little post about why I ggsql makes so much sense to me. Impressive work, congratulations!
carva.lu/posts/i-love...
carva.lu/posts/i-love...
Yesterday we announced the alpha release of #ggsql 🎉 In celebration, here is a ggsql plot for #TidyTuesday Week 16 of 2026, using a dataset on global health spending! 💰
ggsql source: gist.github.com/georgestagg/...
ggsql source: gist.github.com/georgestagg/...
April 21, 2026 at 10:34 AM
Yesterday we announced the alpha release of #ggsql 🎉 In celebration, here is a ggsql plot for #TidyTuesday Week 16 of 2026, using a dataset on global health spending! 💰
ggsql source: gist.github.com/georgestagg/...
ggsql source: gist.github.com/georgestagg/...
I've been hard at work on a new renderer for #ggsql to replace Vega-Lite and it is close to ready for primetime.
Here, you can see it running in the browser, showing of a much improved layout model for faceted plots, along with native markdown rendering
Here, you can see it running in the browser, showing of a much improved layout model for faceted plots, along with native markdown rendering
September 8, 2026 at 10:02 AM
I've been hard at work on a new renderer for #ggsql to replace Vega-Lite and it is close to ready for primetime.
Here, you can see it running in the browser, showing of a much improved layout model for faceted plots, along with native markdown rendering
Here, you can see it running in the browser, showing of a much improved layout model for faceted plots, along with native markdown rendering
This week's #TidyTuesday is about agricultural tariffs in the US. Today I've been working some more on #ggsql, so here is a ggsql plot!
Code: gist.github.com/georgestagg/...
Code: gist.github.com/georgestagg/...
April 28, 2026 at 2:35 PM
This week's #TidyTuesday is about agricultural tariffs in the US. Today I've been working some more on #ggsql, so here is a ggsql plot!
Code: gist.github.com/georgestagg/...
Code: gist.github.com/georgestagg/...
🤯 @posit.co launches ggsql 🤯
- yes it is precisely what it sounds like.
- rust based stand-alone, needs vscode or jupyter (or merely wasm) to run
opensource.posit.co/blog/2026-04...
- yes it is precisely what it sounds like.
- rust based stand-alone, needs vscode or jupyter (or merely wasm) to run
opensource.posit.co/blog/2026-04...
ggsql: A grammar of graphics for SQL
Introducing ggsql, a grammar of graphics for SQL that lets you describe visualizations directly inside SQL queries.
opensource.posit.co
April 21, 2026 at 4:08 PM
🤯 @posit.co launches ggsql 🤯
- yes it is precisely what it sounds like.
- rust based stand-alone, needs vscode or jupyter (or merely wasm) to run
opensource.posit.co/blog/2026-04...
- yes it is precisely what it sounds like.
- rust based stand-alone, needs vscode or jupyter (or merely wasm) to run
opensource.posit.co/blog/2026-04...
Also added to development version of ggsql too 🫡
Try it out in interactive examples at ggsql.org/syntax/coord....
```
VISUALISE continent AS fill FROM ggsql:world
DRAW spatial
PROJECT TO equal_earth
```
Try it out in interactive examples at ggsql.org/syntax/coord....
```
VISUALISE continent AS fill FROM ggsql:world
DRAW spatial
PROJECT TO equal_earth
```
September 7, 2026 at 3:47 PM
Also added to development version of ggsql too 🫡
Try it out in interactive examples at ggsql.org/syntax/coord....
```
VISUALISE continent AS fill FROM ggsql:world
DRAW spatial
PROJECT TO equal_earth
```
Try it out in interactive examples at ggsql.org/syntax/coord....
```
VISUALISE continent AS fill FROM ggsql:world
DRAW spatial
PROJECT TO equal_earth
```
😍We were exceptionally lucky at Statistics Denmark to have @thomasp85.com giving a thorough {ggsql} intro, with a focus on motivation and the theoretical foundations
🗣: In the era of LLMs, READABILITY of the code is essential for humans; SQL tops here 🏆
🔗 slides: thomasp85.github.io/2026_ggsql_4...
🗣: In the era of LLMs, READABILITY of the code is essential for humans; SQL tops here 🏆
🔗 slides: thomasp85.github.io/2026_ggsql_4...
September 26, 2026 at 5:34 AM
😍We were exceptionally lucky at Statistics Denmark to have @thomasp85.com giving a thorough {ggsql} intro, with a focus on motivation and the theoretical foundations
🗣: In the era of LLMs, READABILITY of the code is essential for humans; SQL tops here 🏆
🔗 slides: thomasp85.github.io/2026_ggsql_4...
🗣: In the era of LLMs, READABILITY of the code is essential for humans; SQL tops here 🏆
🔗 slides: thomasp85.github.io/2026_ggsql_4...