Support for virtual (generated) Oracle columns has been added and is defined this way:
sql
CREATE TABLE QGIS.GENERATED_COLUMNS ( "pk" INTEGER PRIMARY KEY, "generated_field" GENERATED ALWAYS AS ('test:' || "pk") VIRTUAL);
Note: It's not possible to define a generated column on an SDO_GEOMETRY field in Oracle.
For now, when creating a new feature, the generated field is editable and should not be. A new API method needs to be added to retrieve readonly field from the provider as discussed in Issue 35995.
This feature was developed by Julien Cabieces