Why are column default values not exported to the SQL table

If you add a column to a SharePoint list and assign a default value to it, SQList will add this column to the corresponding SQL table, but will not fill it with the default value.

The reason is that SharePoint does not fill the column in the list itself when the column is added, and SQList keeps the data in the SQL table in sync with what the list items actually contain. The default value is only applied when a list item is created or modified.

This can be seen when the new column is added to a list view; the column will display an empty value rather than the default value assigned to the column definition.