Faced this issue at least twice in last couple of years, one of the most frustrating and redundant problem to solve.
wrote a blog around handling changing data types while ingesting a JSON data (from mongodb or other no-sql dbs) to a sql environment and how current ETL tools handle such changes