and breaking news that I discovered today... a new SQL standard is coming! http://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new

creating composite unique index without partial not null condition really burned me once. 😃