[TYPO3-project-4-3] fe_group SQL-statement, question out of curiosity

[Martin Kutschker]

Niels Fröhling schrieb:
> Martin Kutschker wrote:
> 
>> Not every function is and should be overloaded by DBAL. Basically only
>> t3lib_db (and some functions of the installer and EM) are and should be
>> handled by DBAL.
> 
>  Do you think in this case we should make the mysql-frontend a bit more
> propriatary and optimizing and leave the DBAL-frontend stay with the
> excessive SQL-statement?

I'm not a fan over fiddling here and there with the SQL code. I may be
convinced that it is worth the hassle if someone profiles the queries.

Anyway, my favourite approach for cross-DB SQL is by SQL generating
code. In the context of the current framework this means a helper
function (in t3lib_db or a new DB-utils class) that generates the SQL
snippet for the DB in question.

Note a: AFAIK the NULL comparison is *only* for Oracle.

Note b: IIRC someone wrote that FIELD and FIND_IN_SET are not reliable.
But I have no idea on what basis this statement has been made.

Masi