RE: [PEAR-DEV] SQL language parser

> 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. > - ... yeah obviously building the query from pieces would give the greatest flexibility fort the wrapper to achieve portability. Then again it takes away a fair amount of flexibility for the user and would introduce some overhead. But you suggested this as an "add-on". Stuff like this will probably also help newbies a bit, although SQL is already quite easy to pick up as it is. But your project indeed would take a pretty big effort to achieve. I think we should first settle on core functionality and an extensible framework. This would allow all those features you suggested to be added later while people could already start working with the core. The core could be in place much faster (more like 1 - 1,5 months). Best regards, Lukas Smith smith@dybnet.de _______________________________ DybNet Internet Solutions GbR Alt Moabit 89 10559 Berlin Tel. : +49 30 83 22 50 00 Fax : +49 30 83 22 50 07 www.dybnet.de info@dybnet.de _______________________________