MSSQL Server has had this capability since forever.

You can even graphically drag-and-drop column order from within SSMS (SQL Server Management Studio), although it’s always seemed sketch AF to me, and I wouldn’t want to do this with a large table unless I had backups and the site/app was set offline due to maintenance.

Even Entity Framework (DotNet) has the ability to define column order, but only on table create (for sure). I cannot remember if an EF migration can insert a column anywhere into the middle or not.

Is that because it's actually inserting/moving the new column at/to the given location or simply choosing to display it as being at that location? Given that one involves rewriting the entire database and the other involves swapping two entries when they're displayed, I know how I'd go it.