Because of this I prefer very light ORMs that abstract almost nothing. Those that provide model definitions, automatic migrations and a one-one SQL mapping.

Any particular recommendations? I tried hibernate in java and was put off by complexity.