Wasn’t expecting some fundamental issues here with some ‘:’
As stated before, the ‘:’ is within the name of fatty acids:
The database has imports/exports/other applications, it’s no option to rename the column-names, all have to be changed, some by third parties. This is not going to happen (costs, time, riscs etc.)
An other solution I used in the past was having a database-view with renamed columns. Always had a lot of discussion with DBA’s and a lot of paperwork to do to get them in place. And could take long time or short time, the view would give trouble (update’s etc.)
Next in line was keeping the renaming within application in some way or another. Apart from the extra work, long-term maintenance gets a problem. It’s not the way to go.
Any other options?
Well, apart from being my usecase, imho it’s a core cakephp question in to what extend it keeps up with database-features (and if not doing so for 100%, it’s ok, but you want to know).
The fact that it’s possible to use ‘‘quoteIdentifiers’ => false/true’ indicates that cakephp is aware of the feature, the query-builder seems to adjust it’s behaviour.
There’s seems to be one more step to take (and it’s ok if you have to change the baked code by hand).