Sunpy 6.0 (astropy) breaking changes and deprecations

[nicHoch]

fits IO has changed:

time columns

columns with unit "s" and data type float can be written but not read in with the QTable.read(file, hdu, astropy_native=True) option any more
this is happening with sci-aspect-burst files

  File "/opt/hostedtoolcache/Python/3.11.13/x64/lib/python3.11/site-packages/astropy/units/quantity.py", line 539, in __new__
    raise TypeError("The value must be a valid Python or Numpy numeric type.")
TypeError: The value must be a valid Python or Numpy numeric type.

removing the astropy_native=True option solves the read error and also old files can be read in.

need to make sure that the astropy_native=False does not break something else