SQL gives you no other options though, there's no other construct that means "not present", since NULL is unknown vs. not present.

It depends on your column. If you have a products table and a certain handmade product has no upc, it’s correct to use ‘’ as its value rather than NULL because you know for a fact that its non-existent. Some people respect NULL too much.