The current version of the package is at
http://multi.zmbh.com:8300/query-writer-0.5.3.apm It has been tested on a large datamodel, but only works with PostgreSQL. There are fewer advantages to using it with Oracle. Currently you can input your datamodel and it will generate pg functions for create/update/delete and object_p. It handles overloaded pg functions, and also works with any table with a single attribute primary key without the pg functions being needed.