[TYPO3-mvc] How to handle reserved words in field definitions? (Kickstarter)

[Steffen Ritter]

Xavier Perseguers schrieb:
> Hi,
> 
>>>> 1) We can add backtics `usage` to the field definition.
>>>> Not a really good solution, as the core doesn't prefix fields at many
>>>> places.
>  >>>
>>> in general i think this should be the way to go, since it is the "most
>>> clean" solution.
>>> If core is not "able" to handle this, we might add it in Core. Probably
>>> this makes it easier for dbal and Xavier too.
>>> But he's the Database expert und should comment on that.
>  >
>> +1 :-)
> 
> In fact, it seems to be the best solution and could easily be done with 
> some method in t3lib_db for instance, just as for quoting strings or by 
> making sure the SQL parser is able to simply parse the backticks. When 
> using DBAL, this would allow to "quote" those definition properly, 
> according to the DBMS-specific list of reserved words or the way they 
> are escaped.
> 
sounds like we found the way to go? anything against it Jochen?

what would be the steps to go for that?
Is it enough to adapt t3lib_db and related or should kickstarters also 
be adapted to generate ext_tables.sql with backticked fieldnames?

regards

Steffen