Many years ago I worked with a database that had 'virtual fields', which are very convenient, and I think will be a wonderful addition to HeidiSQL.
Suppose you have:
Table1:
name: transactions,
fields: customerID, bought_item, date.
Table 2:
name: custromers
fields: customerID. customerName
In order to get a list of transactions that include the customer name, I need a query in order to join the tables.
Instead, it would be nice to add a 'virtual field' to Table1 called customerName, which will not really hold data; rather it will be data extracted from Table2 for the view. Furthermore, once such a field is defined, it can also be used in queries, as if this field is part of Table 1.