SQL language parser

From: Date: Sun, 02 Dec 2001 15:28:01 +0000
Subject: SQL language parser
References: 1  Groups: php.pear.dev 
Request: Send a blank email to pear-dev+get-3292@lists.php.net to get a copy of this message
Jason Lotito wrote: > > > 4.14) SQL language builder/helper/parser (?) > > What exactly do you mean by this? I am intrigued, and if it is what I > think you mean, I have some code to start with. > With that I mean (perhaps wishes): - Ability to split the common fields of a query (for ex: the selected columns, the tables in the FROM, the WHERE part, ORDER BY,..) - Ability to construct a query with certaing given params - Ability to alter certain parts of a SQL statement (for ex: replace the ORDER BY clausule with that, the selected fields by a COUNT, etc) - ... This could help a lot in: - Emulating certain features not natively supported - Automatize the creation of SQL statements - The creation of software to admin databases like: "PhpMyAdmin", PHP GTK/console interfaces, etc. - ... Tomas V.V.Cox

« previous php.pear.dev (#3292) next »