What is the `TABLE example` syntax called?

It's documented with the SELECT statement and it's called "TABLE Command" there.

In the SQL standard it's called an "explicit table":

The <explicit table>

   TABLE <table or query name>

is equivalent to the

   ( SELECT * FROM <table or query name> )

---

This seems to be part of the standard at least since SQL 1992