Reorder columns / edit column order as default view

[RTechSn]

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

Right now it is impossible to reorder columns or show metadata columns on a table without creating a separate view.

Describe the solution you'd like

Create a hidden view object for each table, which would be a default view for this table. Allow users to edit it by clicking Edit table in the menu. Renaming the default view would rename the table, making this solution a complete replacement for the current editing window, which allows renaming only.

Describe alternatives you've considered

Allow to save a view as a default view, itstead of replacing editing dialogue.

Additional context

No response

[datenangebot]

Agree, we should bring the column ordering (without the checkboxes for hiding) and sorting to the "edit table" modal.

Would suggest to reuse the order_weight property for each column as used before and add a sorting property on the db side.