feat(sql): infer not null on pk columns

Summary

• feat(sql): infer not null on pk columns

• update sbroad submodule to commit supporting inferring not null constraint on primary key columns
• remove redundant not null constraint from most integration tests

---

• Close sbroad#682 (closed)
• Cherry-pick to: none
• Docs follow-up: docs#287 (closed)
• Depends on sbroad!465 (merged)