SQLite json_extract coerces JSON false/true to integers 0/1 (absent key returns NULL)

Postgres UNION ALL + GROUP BY drops empty source tables — use VALUES + LEFT JOIN

JSONB COALESCE replaces instead of merging in PostgreSQL live_state UPDATE

PostgreSQL UPDATE with LIMIT requires subquery pattern