Nice, a "sql language standard", but... do we have a standard about how should this query be executed?

for example...
for transactional engines, should it consider the "tx_isolation" variable and execute a particular procedure?

for non transactional engines, should them "lock others inserts" execute the query and return max value?
or we don't have a standard about how to execute it, and each engine do what's "better"?