Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:115035
User-Agent: Cyrus-JMAP/3.5.0-alpha0-530-gd0c265785f-fm-20210616.002-gd0c26578
Mime-Version: 1.0
Message-ID: <6ab93b1c-816e-40d5-a831-2f755fd7aeb5@www.fastmail.com>
In-Reply-To: <9ACF5579-6721-4C23-B725-1018B7971B20@newclarity.net>
References: <4FFA0160-1A05-4DA0-9C9A-79F778443A35@newclarity.net>
 <CAGBsUre=Asp+arHBWK0VdT-YdM=_3rR+WOhQQeghFVwsR+nGUg@mail.gmail.com>
 <F861461F-D070-4808-8B2E-A9BBF753CE6C@newclarity.net>
 <9e8faf2b-fdc7-49f4-bdc1-0822841616e2@www.fastmail.com>
 <9ACF5579-6721-4C23-B725-1018B7971B20@newclarity.net>
Date: Tue, 22 Jun 2021 11:56:24 -0500
To: "php internals" <internals@lists.php.net>
Content-Type: text/plain
Subject: =?UTF-8?Q?Re:_[PHP-DEV]_Sql_Object_Model_Parser_&_Sanitizer_(was_[RFC]_i?=
 =?UTF-8?Q?s=5Fliteral)?=
From: larry@garfieldtech.com ("Larry Garfield")

On Tue, Jun 22, 2021, at 11:46 AM, Mike Schinkel wrote:

> Maybe this will help. There are a billion XML schemas, but DomDocument 
> and its related classes can process them all. A SqlObjectModel would be 
> similar; it would know how to process text queries where the dialect 
> interface implementors would be the equivalent of the XML schema.  
> 
> It is not a perfect analogy, but it is close enough.

It's a very helpful analogy, actually.  SQL is 100x more complex of a language than XML is.  XML is trivial by comparison.  That's exactly why what you describe is vastly harder than you think it is, even if you limit yourself to the rudimentary ancient SQL standards.

And a tool that breaks down and becomes unusable as soon as you start using anything even vaguely modern is a tool I would rather *not* exist, quite frankly, as it only further discourages anyone learning SQL beyond MySQL 3.

--Larry Garfield