Currently, if you set a default for something like timezone.now() the database default will be a static timestamp that is derived from a one-time execution of the default function.
It would be a nice best-effort for timestamp columns that use a default of datetime.datetime.now() or timezone.now() to use the now() db default.