--- title: ggsql: A grammar of graphics for SQL | daily.dev description: Posit has announced the alpha release of ggsql, a new visualization tool that implements the grammar of graphics using SQL syntax. It allows data analysts to... canonical: https://daily.dev/posts/ggsql-a-grammar-of-graphics-for-sql-cjvdglb7o twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: ggsql: A grammar of graphics for SQL | daily.dev og:description: Posit has announced the alpha release of ggsql, a new visualization tool that implements the grammar of graphics using SQL syntax. It allows data analysts to... og:url: https://daily.dev/posts/ggsql-a-grammar-of-graphics-for-sql-cjvdglb7o og:image: https://api.daily.dev/og/posts/cjvdglb7O.png og:image:alt: ggsql: A grammar of graphics for SQL og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # ggsql: A grammar of graphics for SQL **[Hacker News](https://daily.dev/sources/hn)** · 15 min read · 1 upvotes · 0 comments ## Summary Posit has announced the alpha release of ggsql, a new visualization tool that implements the grammar of graphics using SQL syntax. It allows data analysts to describe and build visualizations directly within SQL queries using clauses like VISUALIZE, DRAW, PLACE, SCALE, and LABEL. The tool uses DuckDB as a backend, requires no R or Python runtime, and can push computation down to the database layer — meaning only aggregated results are fetched rather than raw data. It is designed for SQL-native users who lack good visualization options, integrates with Quarto, Jupyter, Positron, and VS Code, and is positioned as LLM-friendly due to SQL's well-understood syntax. Future plans include a Rust-based renderer, theming, interactivity, spatial data support, and a language server. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [SQL expressions in Grafana: Combine and manipulate data from multiple sources](https://daily.dev/posts/sql-expressions-in-grafana-combine-and-manipulate-data-from-multiple-sources-szkanelun) · Grafana Labs · 1 upvotes · 0 comments --- Tags: [#sql](https://daily.dev/tags/sql), [#data-visualization](https://daily.dev/tags/data-visualization) [View this post on daily.dev](https://daily.dev/posts/ggsql-a-grammar-of-graphics-for-sql-cjvdglb7o) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"ggsql: A grammar of graphics for SQL","url":"https://daily.dev/posts/ggsql-a-grammar-of-graphics-for-sql-cjvdglb7o","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/ggsql-a-grammar-of-graphics-for-sql-cjvdglb7o"},"datePublished":"2026-04-20T14:34:35.969Z","dateModified":"2026-04-20T14:35:08.123Z","description":"Posit has announced the alpha release of ggsql, a new visualization tool that implements the grammar of graphics using SQL syntax. It allows data analysts to...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/67c2c37abfc87c2e1d06595c62c69873?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/67c2c37abfc87c2e1d06595c62c69873?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Hacker News","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Hacker News","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/hn","url":"https://daily.dev/sources/hn"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/ggsql-a-grammar-of-graphics-for-sql-cjvdglb7o","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"sql,data-visualization","timeRequired":"PT15M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Hacker News","item":"https://daily.dev/sources/hn"},{"@type":"ListItem","position":3,"name":"ggsql: A grammar of graphics for SQL"}]} ```