Same thing in sql. Non null guarantees are great until you do a left join.