If you can't use stored procedures then use a object/relational persistence layer like http://www.hibernate.org