Feature Request: generated/virtual/calculated columns

Feature Suggestions
1

Different databases call them slightly different things, but I’m looking for support for generated columns as introduced in SQL:2003.

Sample SQL:

CREATE TABLE S (
 COL1 INTEGER,
 COL2 INTEGER,
 COL3 GENERATED ALWAYS AS (COL1 + COL2) )

Further reference:
https://en.wikipedia.org/wiki/Virtual_column

2

I’m using generated columns in a MySQL database and having to store the calculation as a note and then manually edit the exported SQL file before running it. Support for generated columns gets my vote.

3

Upvoting Upvoting Upvoting