Re: SQLizer SQL syntax builder

Hi,

One of our beta testers, an Oracle DBA from a major global manufacturer plans to use it in a in-house application for use by several departmental groups. He had the following to say about SQLizer:

" I searched the net for "SQL query generators" and found quite a lot, I looked more closely at some of them.

It seems there are two categories of query engines, either _really basic_ ones (query one table with constraints on the available columns and maybe sort the resultset) programmed by a Java/SQL newbie, or the _giant_ legacy systems provided by oracle (discoverer) etc usually aimed at datamarts and "non database background" end users.

Your Sqlizer fits nicely _in between_ these two categories, handling complex SQL queries with joins, subqueries, grouping, unions etc, but without too much overhead (sacrifising some ease of use for end users, they must know a little about tables, joins etc). This is ok, since the everyday user of our application is not supposed to do these kind of searches, but it is nice to have the possibility for the more advanced users. An alternative could also be to use saved queries (created by a dba) which end users edit. Since I want to include the query generator in the Java application, a _Java_ query engine is prefered. "

Dave M.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:upnpc6j8726m6b_at_corp.supernews.com...

>
> "David Morse" <davem405_at_attbi.com> wrote in message
> news:v_Mm9.14915$Pz.15285_at_rwcrnsc51.ops.asp.att.net...
> > Hello,
> >
> > We are looking for about 15 beta tester for our SQLizer tool. SQLizer
> > provides a simple intuitive tool for building even the most complex SQL
> > queries; no actual knowledge of SQL is required. Only basic knowledge of
> > database concepts is required to create queries, save them and modify.
> > Queries are built by picking from lists of options and clicking buttons
to
> > proceed. Only basic keyboard entry is required for literal values,
> optional
> > column headings and special options.
> >
> > It is written in 100% Java and designed to be used with any database or
DB
> > application with a JDBC Driver but works great with Oracle.
> >
> > Dave M.
> > dave_at_firstsql.com
> >
> >
>
>
> The IT community is already severely suffering from people exposed to
> 'tools' like this one. Are you saying that someone with NO knowledge of
SQL
> and NO knowledge of Oracle could ever develop a WORKING application?
> Do you know HOW MANY DBAs are on the brink of collapsing by morons using
> products like you seem to offer?
>
> Regards
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>
>
Received on Fri Oct 04 2002 - 22:58:18 CEST