Support `ON COMMIT` clause for `CREATE TEMPORARY TABLE`

The `ON COMMIT` clause of `CREATE TEMPORARY TABLE` controls whether the table is dropped, truncated, or left alone when a SQL transaction occurs. The default in Postgres is to take no action and leave the table and rows in place.

An easy first step for this support could be to enable the syntax so that it doesn't cause an error, and any `ON COMMIT` clause will be a no-op (i.e. equivalent to `ON COMMIT PRESERVE ROWS`, the default). After syntax support, we'll need to dig into GMS to support the real behaviors.

[PostgreSQL docs for `CREATE TEMPORARY TABLE ... ON COMMIT ...`](https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-PARMS-ON-COMMIT)

Originally reported by a customer in: https://github.com/dolthub/doltgresql/issues/2298