[Typo3-dev] quoting SQL-identifiers

[Martin Kutschker]

"Rainer Kuhn" <kuhn at punkt.de> schrieb im Newsbeitrag 
news:mailman.1214.1114417323.11564.typo3-dev at lists.netfielders.de...
>
> So I do not have any influence on the field names, but I have to handle 
> the existing names (including the reserved word MATCH) in the SQL 
> statements of my extension. Therefore some kind of DBAL abstraction is 
> needed; having this done automagically IMO would be best and safest.

Can it handle it this? :-)

SELECT
 a.col1,b.col2 as x,func1(a.col3),vcol1,(SELECT vcol3 FROM t2 WHERE 
id=b.col2)
FROM
 a, y as b, (SELECT vcol1,vcol2 FROM TABLE t1 WHERE id=a.col4) as c
WHERE
 b.col5=func2(vcol2) AND
 a.col6 IN SELECT vcol4 FROM t3

Masi