Virtual and stored generated columns are both available in MySQL. Every time data is read, the virtual columns are calculated instantly, but when data is
Tag: Generated Columns in MySQL
MySQL Generated column from another table
No, if this is what you are trying to achieve, then it isn’t supported in any SQL product. Sometimes we may require a generated/computed column
Big Data & SQL 