In brief I want to know if there is any front end way of adding columns to the accounts table?

I know that you can create custom fields that get added to the accounts_cstm table. However that makes querying and bulk inserting of data from other data sources darn near impossible. (You have to create the unique key in the accounts table, find out what that is then continue your data insert in your custom fields) Not only that, reporting requires way more work because your data’s in two places. So what I’m wondering is if there is a way to do mass custom column creation. I work for an HMO, we track about 50 fields in our accounts that Sugar doesn’t have. Like risk adjustment factors. I would love it if I could just add the fields in the MySQL db and then go back into sugar and give labels to the columns that I’ve added. I the past I’ve added them to the database then gone into the PHP code and manually added the columns to the vardefs.php file for each module then gone back into the studio and placed the new fields into the forms. To be blunt it sucks, especially because almost every upgrade overwrites your changes. Is there light at the end of the tunnel or perpetual query hell?

Thanks!
~Sponj