Testing AI-Generated DDL Against the Rules It Was Given
I asked an AI coding agent for CREATE TABLE DDL from a plain-English spec, then tested every rule on SQL Server 2019 and 2025. Several weren’t enforced.
Proving the Contract Holds: Testing Database Code
The ended with a contract smoke test: a query that fails the build if a published view loses a promised column or changes a promised type. That test is worth having, and it is not…