JSON builders, DISTINCT ON, collation & generated columns
Odds and ends unique to PostgreSQL: JSONObject/JSONArray build JSON from columns; .distinct('author') is SQL DISTINCT ON (one row per author); a non-deterministic db_collation makes nickname comparisons case-insensitive; and a GeneratedField …