Since this is now waiting for v13, there's a bit more time to entertain the question of whether we'd rather have these in psql or in a new server command DESCRIBE [verbose] [system], and if so, whether the output of that would itself be query-able or not.
Including this feature in core can be nice. If they are on server side, then should to produce result via API - like EXPLAIN. That's all.