Le 22/06/2021 à 11:28, Dan Ackroyd a écrit :
On Tue, 22 Jun 2021 at 10:25, Mike Schinkel <m...@newclarity.net> wrote:
Should(n't?) PHP add a basic SQL builder class that can be extended for special
cases, e.g. different flavors of SQL?
No. Or at least not yet.
This type of thing is much better done in userland, where the api can
evolve at a fast rate, rather than being limited by the fixed release
schedule of PHP.
Agreed, PHP is probably not the right place for an SQL builder, there's
too many dialects, too many standard or non-standard features, in the
end SQL builders almost always end-up being opinionated by its
designer's original need, philosophy, or SQL usage habits, and tailored
for users which use certain paradigms.
An SQL query builder is already business domain tied, in some way. Of
course most are very generic, but often don't handle properly SQL
advanced or modern features, whereas some other where built for ORMs and
such and may a reduced advanced SQL features that fits the original need.
I don't wish to see an SQL query builder in PHP core, instead of
favoring usage of modern SQL, it'll in my opinion (of course, that's
subjective) lower the expectation of people and probably normalize
SQL-92 being the only SQL spoken by people writing PHP (just
exaggerating a bit).
Regards
--
Pierre
--
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: https://www.php.net/unsub.php
