I'm getting my feet wet with SQL and exploring the differences between using MySQL and Google Sheets. One huge benefit that i really like so far is that i can add columns in the SQL database and AppSheet doesn't care. It won't have access to the new columns until regenerated in AppSheet, but it won't break either.
My question is, it looks like virtual columns are a thing in SQL as well (forgive me, i am very much a sql rookie). So let's take a very simple example like concatenating a last name and first name
Is that best done with a virtual column in appsheet, or should i do it in sql?
I suppose it's easy enough for me to test, but at the moment, my experiment is with very simple databases, and i'd like to better understand best practices at scale.
Thanks
LinkedIn
Twitter
