Has anyone used my query-writer? It started as an attempt to eliminate writing any queries at all, no .xql files for insert/update/delete. Unfortunately it has a bad ui for adding new functions. I started working on an update last week and hope to complete the project in the next few weeks. What it will do is take a table name, one already created in the db and figure out what the insert/update/delete pl code would look like and create it. It figures out if the table pk traces back to acs_objects and if so, uses a function call to create the parent object, then inserts data into the new table. For updating data, It might use regular dml statements and avoid pl/sql altogeather. The package will have an expanded capability to define your own 'tweaked' pl code.
It has built in capability to distinquish between pg and oracle, and would run the correct procedure for creating the pl/dml on the fly.
It is currently pg specific since the main focus was to eliminate the need to remember attribute order, attribute defaults, and even the number of attributes to a function call. It can handle overloaded pg functions without the need for the developer to be aware of which function is being used.
It has an api that can be used in an .xql file, one that can be used in a tcl file, and a url based api as well.
The current package is at http://zmbh.com/query-writer/
