Reading up on sql

The article details surprising PostgreSQL SQL quirks: alias column pass‑through, ambiguous table/column names, interchangeable function/column syntax, multiple cast styles, composite types, table‑returning functions, and type coercion oddities.

dbt Charts introduces a declarative YAML syntax for building auditable dashboards on top of SQL, compiling board definitions into interactive reports across multiple formats while integrating with dbt projects for unified version control and CI validation.

the-stats-duck v0.6.0 adds OLS regression, bootstrap, expanded distributions, and a Vega-Lite plot grammar to DuckDB SQL.

A developer built a free, open-source browser-based tool that converts SQL CREATE TABLE statements into interactive ER diagrams without uploading data to any server.

DuckDB's full-text search extension offers BM25 scoring, stemming, and stop-word removal but lacks result highlighting and phrase queries.

A senior engineer's drunken list of candid career advice criticizes interview processes, praises dynamic languages, and emphasizes documentation and financial planning.

Myflames converts MySQL EXPLAIN ANALYZE JSON into interactive flamegraph SVGs and a compact text digest that reduces LLM input tokens by 75% for query diagnosis.

Repere is a local-first SQL data explorer that runs entirely in the browser via DuckDB WASM, enabling private, serverless spreadsheet-style querying and transformation of CSV, JSON, Parquet, or Excel files.