If you want to see paranoid SQL for Postgres, look at the output of pg_dump (with the default text format.) For every strange-looking bit of SQL syntax pg_dump prefers to the "usual", there's a story behind that choice — usually one involving some customization some tenant or DBA could do to the DB that would break the semantics of the regular SQL.