We have extend Valentina SQL by non standard feature. DEFAULT clause now has form DEFAULT METHOD(‘const_expr’).
This step increases declarative power of DDL part of VSQL and, therefore, allows you do less job later working with inserts and updates.
You can use in the expression built-in Valentina functions and UDFs that not depends on other fields. The most useful examples are:
* now()
* UUID()
* nextval( sequence_name )
* current_user_name()
Compatibility:
* this is not standard syntax.
* PostgreSQL have similar syntax and behavior, but it specify expression just in the literal: DEFAULT STRING_LITERAL. This cause ambiguity.