It’s used in Neon’s web-based console to support \d and friends alongside regular SQL queries.

You might well never need to use it, but if you’re building an online query editor it could be very handy!

Yeah, I don't really get where / how I would use this. The documentation is really lacking on outlining the usage / use-case.