This is a basic idea that Advanced Lists are necessary and need a facelift.
The simple fact that the recent very useful "Group Contact Tracing" list BB implemented had to be implemented using Adv. Lists illustrates this. It also illustrates that inherent limitations in SKY lists is not enough.
Some changes needed to Adv. Lists:
Add all tables and fields. [newer stuff is missing]
Put together a searchable data model diagram so one can find a particular field and how it would fit into a list
Make editing more useful:
Allow drag and drop of filters and objects
Put in a Save As
Where there are enumerated values, put up a selection box instead of requiring one to type in a value
Explain the difference betw. filtering by 'Where' clause vice in 'Join'. (Examples!)