How is MSSQL so popular? "Oh yeah, sometimes you have to use dynamic SQL because the compiler doesn't correctly detect the impact of DDL commands and rejects working code" god fucking what? Why does the compiler infer the future structure of tables after a DDL command if it can't do so reliably? In my world, if it becomes public knowledge that a compiler incorrectly infers something, the maintainer scrambles to remove the inference instead.

I also find it surreal that I have to disengage versioning on a table in order to be able to modify the version history. Like surely, there should be a mechanism to temporarily skip the hooks other than ALTERing the table into a regular unversioned database table and then ALTERing it back, rebuilding the versioning infrastructure from scratch. SQL is awful and MSSQL is doubly awful.