It basically allows you to do what you are doing without having to manage tables by adding and removing columns.

The idea is simple, preemptively create a table with a certain distribution of column types and then allow the developer to define models in their app and map properties of their model to available columns.

It is a pretty robust idea and works well, we use it in our product.

I'll be doing a thorough write up on it sometime in the near future.