General SQL Design Patterns: Documented Failure Modes and Decision Thresholds

Cross-engine SQL guidance beyond textbook fundamentals: the GitLab 2017 backup-failure postmortem, why REPEATABLE READ silently permits write skew, sourced connection-pool sizing formulas, and SQL:2023's JSON type and pr...