Thanks. I checked and dbeaver can indeed store columns ordering as a filtered view.
Seems like a bit overcomplicated to me but I guess I've been spoiled with mysql in which the ordering is trivial.
visual example : https://www.w3resource.com/sql-exercises/sql-retrieve-exerci...
verbal examples : discussion on various ways to reorder columns : https://stackoverflow.com/questions/1605144/how-to-change-co...
Your select statement specified the order of your result columns in your result set. Your visualization tools should have the option to reorder the displayed columns to your liking or need.