I am writing a querybuilder to QUICKEN developer work. Below is what I set as plan. Let me know if you know any such tools.<p>Initial Agenda:
1) Create Table/View<p>option to add primary/foreign key
Create indexes on columns
Null/Not Null/Check constraints for each column<p>2) Insert / Update / Delete / Select
where condition
"and" operator
"order by"/"group by"/"having" clauses<p>Till Now:<p>Fetching metadata was easy and I have just added JavaScript sugar code using jquery to put things into place.
I am able to get proper sql for around 60% CRUD cases which we require in day to day DB operations. Lets see whether this works out well or not.<p>What next?<p>I am thinking of make this work across databases db2/oracle/mysql.<p>Advantages:<p>For users who just need simple operations with tables can use this thin web client. For small firms can
simply get rid of the license fees for most of the developer machines.<p>Things to look:<p>Need to search whether such commercial applications are available<p>Ideas:<p>Write DSL ( on top of/ using ) JQuery for commmon db operations; which can return me back correct sql.