I'm always frustrated when add column with default values and is nullable.
I always modify a statement as below.

before

ALTER TABLE [dbo].[TableName]
    ADD [ColumnName] VARCHAR (1) DEFAULT ('0') NULL;

after

ALTER TABLE [dbo].[TableName]
    ADD [ColumnName] VARCHAR (1) NULL DEFAULT ('0') WITH VALUES;

Describe the solution you'd like
Add deploy option that insert 'with values' to "ALTER TABLE ... ADD ..." statement.