Revisiting ALTER COLUMN POSITION support

Hi,

I'd like to reopen the discussion about adding support for reorderable
columns (e.g. ALTER COLUMN POSITION or ALTER COLUMN ... AFTER ...).

This request has existed for many years, and there is already a documented
outline and reasoning here:
https://wiki.postgresql.org/wiki/Alter_column_position
<https://wiki.postgresql.org/wiki/Alter_column_position?utm_source=chatgpt.com>

The lack of this feature becomes a real issue in long-term schemas with
large and evolving tables. While PostgreSQL assumes column order is
cosmetic, in real-world environments the ability to logically group and
reorder columns significantly improves maintainability, onboarding, query
readability and workflow efficiency — especially when tables grow over
several years and may contain dozens or hundreds of fields.

Other major databases provide this functionality (MySQL, MariaDB, SQL
Server, Oracle), and PostgreSQL is increasingly used in large SaaS systems
and enterprise environments where schema evolution and human readability
matter.

I understand this requires internal architectural work (physical vs logical
ordering identifiers), but since the request keeps resurfacing, I'm asking
whether this can be reconsidered for a future release — or if there is any
active discussion, proposal or roadmap direction related to it.

Thanks.