In the SQL Editor, please add the

serial

datatype as a drop-down option for auto-complete. The datatype already functions, it's just not obvious it's available. https://www.postgresql.org/docs/current/datatype-numeric.html#DATATYPE-SERIAL