statistics that live in your SQL

https://kolistat.com/blog/the-stats-duck-v0-6-0/ Announcement of a really neat duckdb extension called the-stats-duck (KoliStat/the-stats-duck) which puts statistical functions inside duckDB. It then goes on to add some visualization in duckdb sql, by serializing out to vega-lite format, á la ggsql (which the author calls out on news.yc as a direct inspiration) My favorite bit is the function meta() as a table-valued function, allowing you to select from it: SELECT column_name, kind, n_missing , n_distinct, mean, median, stddev, top FROM meta('penguins'); I don't use R, but I think that's basically the same as its summary() function. It also builds in LOESS regression and embeds an R-like specification language for it: SELECT * FROM lm_summary( 'penguins' , formula := 'body_mass_g ~ flipper_length_mm + bill_length_mm' ); Also, neat job building the demo into WASM and serving it as part of the page, strong work.