Improve sidebar sorting: group shared table views and revisit table ordering

Problem

Currently, when a user is shared multiple views of the same table without having access to the parent table itself, these views appear in the sidebar navigation as independent entries. They are not ordered next to each other, leading to a confusing user experience. In general, the logic for sorting tables and their views in the sidebar could benefit from a review and potential redesign.

Proposal

• Ensure that all views belonging to the same table (even when only shared individually) are grouped together or ordered logically in the sidebar navigation.
• Consider ways to visually indicate the relationship between table views, especially for users who cannot see the parent table.
• Re-discuss and define the overall ordering principles for tables and shared views in the sidebar.
  • Should personal/shared tables be grouped?
  • How are favorites, recents, and alphabetical order respected?

Start by locating the sidebar navigation and the code that sorts tables and shared views; the issue names no specific files or tests. First clarify the ordering rules for personal/shared tables, favorites, recents, and alphabetical order, then define how views relate visually when the parent table is inaccessible. Done means the agreed grouping and ordering work consistently for individually shared views.