Loving those JSON improvements. Looking forward to migrating away from jsonb_build_object and its ilk. They served me well, but were hardly elegant. Now the JSON can look more like... well... JSON.

MERGE will definitely fill in some logical gaps for me as well. A bit wordy but super powerful. Unlike the logic in application tier, there can now be true transactional safety instead of "good enough with the occasional error and/or clean up script" that happens now. Data consistency belongs in the database, not the app.