add fields directly to node table?
Perhaps this is not drupal standard, sometimes is needed to do things like that.

I prefer to create my own entities that to modify the node entity. This way if you use entity api as base this is integrated with views out of the box. Another approach to that not require coding is ECK module, you can define properties to the entity and this will be added on the same entity table as and extra column.