Temporary use of 'quoteIdentifiers' / autoquoting in database queries?

Need Help
1

I notice here: Database Basics - 5.x that autoquoting identifiers is not recommended, for performance reasons.

However I have a legacy database with a table column name which is a reserved word: ‘long’. Queries involving this table cause errors unless I enclose the column names in quotation marks.

I wondered if there is a way to set the autoquoting to be true only when running queries from a particular controller?

Or alternatively, how I might go about writing verbose sql queries in that controller, rather than using the ORM conventions.

2

Well, I found one way of achieving this. I created a custom connection with 'quoteIdentifiers' => true and specified that as the default connection for the model causing the issue.