Ansi SQL: Auto Numbered Column
Yes there is, and it's definitely not "a new standard". It's been in the SQL standard since SQL:2003

The definition is:

&lt;identity column specification&gt; ::=
  GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY
    [ &lt;left paren&gt; &lt;common sequence generator options&gt; &lt;right paren&gt; ]


The optional part with the sequence generator options lets you define the characteristics of the underlying sequence (=generator), you could do something like:

id integer GENERATED ALWAYS AS IDENTITY (start with 42 increment by 10 cycle)


This syntax is supported (at least) by PostgreSQL 10, Oracle 12.1, DB2, Apache Derby, HSQLDB, Firebird and NuoDB.