sql

DuckDB 1.5.2 adds production-ready DuckLake v1.0 lakehouse format, Iceberg extension improvements, Jepsen testing, and a revamped browser shell with file storage.

ggsql is an alpha-release tool that brings grammar of graphics visualization capabilities to SQL, allowing users to create structured, modular visualizations using SQL syntax across Quarto, Jupyter, Positron, and VS Code.

Posit has announced the alpha release of ggsql, a new SQL language extension that brings grammar-of-graphics-style data visualization to SQL, compatible with Quarto, Jupyter notebooks, Positron, and VS Code. It allows users to create layered, structured visualizations using familiar SQL syntax inspired by ggplot2.

Simon Willison shares techniques for fetching data from Datasette into Google Sheets using SQL functions, including importdata(), named functions, and Google Apps Script methods with API token support.

SQLite 3.53.0 releases with significant accumulated improvements including ALTER TABLE constraint modifications, new JSON functions (json_array_insert), and major CLI mode enhancements via a new Query Results Formatter library.

Interactive WebAssembly-based demo for SQLite Query Result Formatter that allows users to format SQL query results in 20+ styles including tables, CSV, JSON, HTML, and Markdown with real-time adjustments.