I want to create a class in lib folder , from that class want to create mysql view . such as in mysql CREATE VIEW rocket_current_activities AS SELECT rocket_activities.status AS status from rocket_activities.... This can be do in mysql but how to do from rails. I dont want in migration file. Please help!!!