- There's currently no native `\d`-style way to explore which tables are using a given TAM.
There's also no way to list which tables are unlogged. Or which have autovacuum disabled. Or which belong to a specific tablespace. All of which are arguably more commonly requested than a TAM.
Perhaps there could be a more generic table-filtering mechanism for \d, but carving something out for such a niche case seems unwarranted, IMO.
Downstream, you wrote:
Not everyone wants to write or remember complex queries
True - but you can write a view or a function to support those cases.