Not to sound flippant, but there's your first problem. Rails really doesn't want to be layered over an legacy database schema. Doing so would definitely lead to

Not to sound flippant, but there's your first problem. Rails really doesn't want to be layered over an legacy database schema. Doing so would definitely lead to essay-like queries.