SQLPostgreSQL autogenerated interval
Jump to Section
Using postgres specific SQL syntax we can create autogenerated column which subtracts two dates and stores them as interval.
age function is also null-safe, so if
time_started it will not crash.
ALTER TABLE session ADD COLUMN duration interval GENERATED ALWAYS AS (age(time_ended, time_started)) STORED;