Re: change natural column order

Regarding the "Natural Order" of columns.

Why if we can delete a column from the middle of a table now, change the type of that column to something totally different, eg text -> int.
Can we not move the order of the rows around, and when the new row is written to disk in the new arrangement.  Or more accurately,
why is it not possible to add a new column, not at the end of the list.  It's probably more complicated that I think, as that's usually the case.

We don't need logical and physical mapping, probably just the ability to insert a column not on the end.

Sorry if this comment is in the wrong place, I've been following the General and Hackers discussions and decided to post now after
deleting the other posts.

Regards

Russell Smith.