To create a virtual generated column, you can use the following sample syntax:

ALTER TABLE tablename 
ADD COLUMN columnname datatype GENERATED ALWAYS AS (expression) AFTER column; 

To create a stored generated column, you can use the following sample syntax:

ALTER TABLE tablename 
ADD COLUMN columnname datatype GENERATED ALWAYS AS (expression) STORED AFTER column;