From: Ezra Zygmuntowicz <ezmobius@...>
Date: 2006-10-10T03:21:35+09:00
Subject: Re: [ANN] SqlStatement 1.0.0 - hide the syntax of SQL behind familiar ruby syntax


On Oct 9, 2006, at 7:50 AM, Ken Bloom wrote:

> sqlstatement - Generate complex SQL statements programmatically
>
> The main goal of this library is to be able to construct an SQL
> statement from "slices" that concern different aspects of the final
> query (perhaps in different places in your code) and then combine them
> all together into one statement easily.
>
> Another important goal of this library is to give some consistent Ruby
> syntax to three statements (INSERT, SELECT, and UPDATE) that seem to
> have different enough syntax that one has two write different code to
> generate each kind of statement.
>
> I use my SQL database (specifically MySQL) largely as a bulk data
> processing engine, by doing INSERT...SELECT or CREATE TABLE...SELECT
> statements. This library is intended to make that kind of coding  
> easier.
> I expect that Object Relational mappers (such as ActiveRecord) are  
> more
> useful for most people, who are performing queries and
> inserting/updating/querying for individual records. I have  
> nevertheless
> added INSERT...VALUES statements, and will add other statements  
> soon, for
> consistency.
>
> This library is inspired by CLSQL for Common LISP, or SchemeQL for
> Scheme, although it is very different from these two libraries. Scheme
> and LISP�s use of s-expressions make it very easy to construct an  
> entire
> sublanguage for the WHERE clause, simply by list parsing. The Criteria
> library for Ruby has attempted this, but in a more limited manner than
> SchemeQL or CLSQL. My library aims to cover much of the  
> functionality in
> these libraries.
>
> This library doesn�t try to abstract out the limitations of your DBMS,
> and I think that the SQL it uses should be fairly portable, in large
> measure because it hasn�t attempted to deal with serious CREATE TABLE
> statements, where a lot of syntax concerning types, keys and sequences
> is much more variable.
>
> This library can be downloaded from
> http://rubyforge.org/projects/sqlstatement/
> Its rdoc documentation is online at http://sqlstatement.rubyforge.org/
>
> License: BSD license
>
> -- 
> Ken Bloom. PhD candidate. Linguistic Cognition Laboratory.
>


Hi Ken-

	This sounds really cool. But I don't see any examples really in the  
docs. Do you have a page with some simple examples of how you would  
use this and why its so cool?

Cheers-
-Ezra