Can you plot in SQL? You can NOW with ggsql! | Thomas Pedersen | Data Science Hangout @PositPBC
Can you plot in SQL? You can NOW with ggsql! | Thomas Pedersen | Data Science Hangout  @PositPBC
Uploaded October 2026 | Updated November 2026, 11 hours ago
Yes, you can! ggsql brings plotting to SQL using the Grammar of Graphics! You get to write in familiar SQL syntax, add data visualization clauses (yep!), and then get gorgeous charts, all without switching to a different tool.

The Data Science Lab is a live weekly call. Register at pos.it/dslab! Discord invites go out each week on lives calls. We'd love to have you! It's is an open, messy space for learning and asking questions. Think of it like pair coding with a friend or two. Learn something new, and share what you know to help others grow.

On this call, Thomas Pedersen, Principal Software Engineer at Posit and author of R viz packages like ggforce, patchwork, and ggfx, tells us all about ggsql. He walks through the website where you can install it, a live web-based playground where you can test it out stress-free, and how to use it in the Positron IDE, too.

Hosting crew from Posit: Libby Heeren, Isabella Velasquez

Thomas Pedersen's socials and urls:
website: data-imaginist.com/about
GitHub: github.com/thomasp85
Bluesky: https://bsky.app/profile/thomasp85.com
LinkedIn: linkedin.com/in/thomasp85

Resources:
ggsql website: ggsql.org
ggsql playground: ggsql.org/wasm
ggsql GitHub repo: github.com/posit-dev/ggsql
Posit Open Source blog post on ggsql: opensource.posit.co/blog/2026-04-20_ggsql_alpha_release
ggsql Python package: ggsql.org/get_started/tooling/python.html
Installing ggsql in Positron: ggsql.org/get_started/installation.html
What is the Grammar of graphics?: en.wikipedia.org/wiki/Wilkinson's_Grammar_of_Graphics

Also, check out Dylan Poulsen's blog post exploring ggsql: dylanpoulsen.com/posts/2026-06-16-ggsql-swimming.html
And Thomas's awesome ART: https://thomaslinpedersen.art/
Can you plot in SQL? You can NOW with ggsql! | Thomas Pedersen | Data Science HangoutVerify launcher-sessions-callback-addressClaude Code without typing anything πŸ€·πŸ»β€β™‚οΈ | Joey Marshall | Data Science LabBuilding Reproducible Pipelines in R | Will Landau | Data Science HangoutFun data science side projects | Damie Pak, Mark Rieke, & Sam Parmar | Data Science LabHow Brilliant Earth Modernized Its Analytics Stack with Snowflake and PositCommunicating complex statistical findings | Liz Eisenhauer | Data Science HangoutHow well do LLMs build Shiny apps? How do we test that? | Karan Gathani | Data Science LabKelly Bodwin: Quarto hacks, AI in the classroom, and why R should stay weirdHow can you add AI voice agents to a mobile Shiny app? | Lucas Da Silva | DS LabThe Answer Was Never Us β€” with Leilani BattleMind-Blowing Quarto Slide Extensions πŸ’¬ πŸ–οΈ 🀯 | Emil Hvitfeldt | Data Science Lab
Posit PBC |

Can you plot in SQL? You can NOW with ggsql! | Thomas Pedersen | Data Science Hangout

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER