SQL Order-Equivalence

The ANY_VALUE Aggregate Function: New in SQL:2023 — and a better feature from 1999

The curious case of the aggregation query

Free Resources Around the SQL Standard

SQL reserved words – An empirical list

MD5 (Algorithm) in SQL

SQL’s Merge performs Insert, Update and Delete operations based on when…then rules

Modern SQL has nice features that are not available through JPA. Blaze-Persistence provides mappings for them.

Java and SQL, Stronger Together

PostgreSQL 11 Reestablishes Window Functions Leadership

SQLite in 2018: A state of the art SQL dialect

Modern SQL: Evolution of a dinosaur [PDF slides]

What parts of Standard SQL aren't implemented in PostgreSQL?

One Giant Leap for SQL: MySQL 8.0 Released

Null in SQL: Indicating the Absence of Data

Pivot – Rows to Columns

Modern SQL Features Where PostgreSQL Beats its Competitors

Modern SQL: Three-Valued Logic (3VL) — Purpose, Benefits and Special Cases

IS DISTINCT FROM — treat two NULL values as the same

Modern SQL: NULL — purpose, comparisons, NULL in expressions, mapping to/from NULL

Literate SQL

SQL WITH: Performance Impacts

The SQL filter clause: selective aggregates – e.g., to pivot data

Literate SQL by Markus Winand

Modern SQL: With – Organize Complex Queries