Ability to change column type

Is your feature request related to a problem? Please describe.

I have created a table and wanted to change the ownership to another user. Since I did not find a way to do so, I've exported the data to csv and imported it as the other user. My boolean values Yes/No were switched to 1/0 and I am unable to change them back to a proper Boolean (with Checkmark in the Frontend).

I think this might affect other column types as well since csv wont be able to save additional info on the column.

Describe the solution you'd like

The ability to change from one column-type to another. Of course this needs to warn about possible data loss and/or be selective about which type change is possible (i.e. number to text, text to number)

Describe alternatives you've considered

I could just create another column and manually enter the correct value there, but this is not feasible for more than a couple of entries.

Additional context

No response

Start by reviewing the issue's proposed column-type conversion behavior and the existing table frontend entry points for column types. Define which conversions are supported, how warnings or data-loss handling should work, and how completion will be verified; the issue names no files or tests to guide implementation.