A product manager argues against excessive documentation, explaining why linking unrelated features can create clutter and maintenance issues.
Explains how to emulate SQL's FILTER clause for JSON aggregate functions in Oracle, addressing NULL value handling in JSON arrays and objects.
Explains Oracle-specific SQL techniques for retrieving the top 1 row per group, covering KEEP syntax, ANY_VALUE(), and object/JSON workarounds.
Analyzes the performance difference between SQL's FILTER clause and CASE expressions in aggregate functions, using PostgreSQL benchmarks.
Article discusses SQLite's limited built-in functions, compares it to other databases, and introduces a Go-based standard library extension.
