ggsql vs TimesFM 2.5

ggsql is an alpha-stage visualization tool from Posit (makers of RStudio) that brings the grammar of graphics directly into SQL. Instead of exporting to R or Python for plotting, analysts can write VISUALIZE statements alongside their SQL queries and get publication-quality charts as output. The syntax is designed to be spoken aloud: "VISUALIZE bill_len AS x, bill_dep AS y FROM ggsql:penguins DRAW point" is a readable declaration, not a configuration object. The project comes from a credible lineage: built by Thomas Lin Pedersen, Teun Van den Brand, George Stagg, and Hadley Wickham — the team behind ggplot2, the most-downloaded R package of all time. Hadley's involvement signals this isn't an experiment from a junior team; it's a considered effort to bring the ggplot philosophy to SQL-native workflows. Outputs render as self-contained HTML with inline SVG charts (no JavaScript runtime required) and PDF exports, usable in Quarto, Jupyter, Positron, and VS Code. With 281 points on Hacker News on launch day, the reception reflects genuine excitement from the data analytics community. The SQL-native approach matters because it meets analysts where they already work — rather than asking them to learn yet another visualization library. Whether ggsql becomes a standard layer in the modern data stack depends on how the alpha stabilizes, but the concept and team behind it are both strong.

TimesFM 2.5 is the latest update to Google Research's pretrained time-series foundation model — a 200M parameter decoder-only model that does zero-shot forecasting across virtually any time-series domain without needing to retrain or fine-tune. Released March 31, 2026, it expands context length to 16,000 time steps (up from earlier versions) and adds an optional 30M continuous quantile head for probabilistic forecasting up to 1,000 steps ahead. Unlike traditional forecasting approaches that require training a new model per dataset, TimesFM was pre-trained on 100 billion real-world time points across diverse domains. You point it at new data — retail sales, server metrics, energy demand, financial prices — and it forecasts without any additional training. The March 31 update also restores covariate (XReg) support and updates inference APIs for better integration. With 14,000 GitHub stars and trending today, TimesFM is becoming the default baseline for time-series work in the same way BERT became the baseline for NLP tasks. Google Cloud users get it directly via BigQuery ML's AI.FORECAST function. For everyone else, it's available on HuggingFace and installable as a Python package.