ggsql

https://ggsql.org/ ggsql brings the elegance of the Grammar of Graphics to SQL. Write familiar queries, add visualization clauses, and see your data transform into beautiful, composable charts — no context switching, no separate tools, just SQL with superpowers. ggsql introduces the VISUALIZE keyword into its sql dialect, allowing you to do grammar of graphics charts from SQL queries. The home page has an example: -- Regular query SELECT * FROM ggsql:penguins WHERE island = 'Biscoe' -- Followed by visualization declaration VISUALISE bill_len AS x, bill_dep AS y, body_mass AS fill DRAW point PLACE rule SETTING slope => 0.4, y => -1 SCALE BINNED fill LABEL title => 'Relationship between bill dimensions in 3 species of penguins', x => 'Bill length (mm)', y => 'Bill depth (mm)' There's an introductory blog post here: https://opensource.posit.co/blog/2026-04-20_ggsql_alpha_release/ with some more motivations and introductory text