That's what generated columns [0] are for ;) There is very little you can't do on the side of the database these days. And if all of it fails, then stored proce

That's what generated columns [0] are for ;) There is very little you can't do on the side of the database these days. And if all of it fails, then stored procedures and triggers can solve the rest. We [1] as a rule don't allow any data to be post-processed once they leave the database and we run database of 100TB+ with trillions of rows with absolutely no problems. [0] https://www.postgresql.org/docs/current/ddl-generated-columns.html https://www.postgresql.org/docs/current/ddl-generated-column... [1] https://www.citusdata.com/customers/pex https://www.citusdata.com/customers/pex