SIE.7:8 - Common Anti-Patterns and How to Avoid Them

Anti-pattern	Repair
SQL is the mapping	Extract the semantic rule, premises, loss, errors, and tests; treat SQL as one implementation.
Crosswalk equals transformation	Add selection, direction, cardinality, conversions, defaults, errors, trace, and examples.
Null for every failure	Define distinct semantic and operational states and their receiver behavior.
Latest record wins	Use the direct configuration/effectivity or justified interval rule.
Normalize identifiers	Preserve scheme and issuer and reference the identity disposition.
Hidden unit conversion	Record source/target units, authority, precision, loss, and counterexample tests.