On Wed, Jul 26, 2006 at 10:21:01AM -0500, Aaron Bono wrote:
> Bottom line though, just how difficult is SQL to read and write anyway? It
> is a hell of a lot easier to read and write than any other computer language
> I have seen.
It's not SQL. It's the notion of relations. If the language were
On 7/25/06, Chris Browne <[EMAIL PROTECTED]> wrote:
"Bit Byter" <[EMAIL PROTECTED]> writes:> I would like to know what the underlying SQL statement will look> like, so that I can use this knowlege to build a generic parser that
> creates SQL statements from the "English like" text, using the> synta
> A typical query then may look like this:
>
> Select all 'toys' from 'Walmart' where average_sales(100) > 10 and
> avaerage_cost(100,10) <= 1 and item_date between "01-Jan-00" and
> "01-Jan-06"
See Microsoft's English Query for SQL Server or the SQ-HAL project for examples:
http://www.micr
"Bit Byter" <[EMAIL PROTECTED]> writes:
> I would like to know what the underlying SQL statement will look
> like, so that I can use this knowlege to build a generic parser that
> creates SQL statements from the "English like" text, using the
> syntax I described above.
I seem to recall that Lotus
1) If you don't know how to write the SQL for this, then you might want
to ask yourself if you have sufficient expertise to write a tool which
generates such queries.
2) I have seen many attempts at query generators. I have yet to see a
design which achieves a good balance between simplicity and
f
