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.