ALTER MODIFY COLUMN now requires explicit DEFAULT

ALTER MODIFY COLUMN now requires explicit DEFAULT when converting nullable columns to non-nullable types. Previously such ALTERs could get stuck with cannot convert null to not null errors, now NULLs are replaced with column's default expression. Resolves #5985. #84770 (Vladimir Cherkasov).