Ability to write our own SQL code

I would love to be able to write SQL code to create custom fields and views. It would save me quite a bit of time and allow me to better meet client needs. Thank you for your consideration.