Custom columns (and any other preferences set in the database rather than in the config folder) can be restored from the "metadata_db_prefs_backup.json" file that sits next to the metadata.db
It sounds like the prefs backup was broken or missing.
This is one reason why restoring the database does not always fix everything -- although it certainly tries to recover as much information as it can!
...
Do you have any backups?