I normally use pandas for that prior to loading to the database (I attempt to create a flat CSV file as raw as possible)