unique constraints with `NULL`able columns
some versions of the sql standard dictate that NULL values do not compare
equal. this can make creating unique indexes with NULLable column members
difficult. but it can be done with this semi-clean workaround!
2022-09-10 14:00:00