Consider automating future schema updates for covid_hosp

[krivard]

Schema updates for covid_hosp are a huge pain, since there are three sets of 100+ column names to diff, many of which need to have separate spellings in SQL to comply with stricter naming requirements, plus different spellings of data types in SQL vs Python. Consider automating this procedure using a similar setup to what we have for advanced meta.

ah! I mean this: https://github.com/cmu-delphi/delphi-epidata/blob/dev/.github/workflows/update_gdocs_data.yml

ie

1. pull down a copy of the csv from the spreadsheet
2. sanitize the bejeezus out of it to make sure we don't end up in a Bobby Tables situation
3. parse it into covid_hosp.sql and database.py x3 automatically

Originally posted by @krivard in #720 (comment)

[krivard]

...I found my old half-finished code. It is not very good, but maybe it will help you get started:

covid_hosp_auto.zip

[krivard]

Cleaner but still incomplete version in progress at krivard/covid_hosp_auto

Probably best to start with the auto-updater section in the README.

Unit tests for this work