SQLite to MySQL Database Migration Error because column is named "LocalTimestamp"

[prabaswara951]

I was trying to migrate my database from an existing SQLite to another, currently running MySQL database with dbeaver's Export Data tool as written here but kept getting a syntax error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LocalTimestamp,[...]' at line 1

After trying out the queries myself one by one, I figured out the problem was specifically because of a column was named "LocalTimestamp" which was a reserved keyword for the LOCALTIMESTAMP() function. So I tried manually adding backtick (`LocalTimestamp`) in the [Costumise ...] setting, but then dbeaver just removes the backticks and the error remains. Adding more backticks forces dbeaver to create a new column instead, which predictably causes an error because the column already exists. Is there a way to force dbeaver to use quotes on the column names? Or some other way to handle this problem?

Note:

1. The existing table columns in the target MySQL database must remain unchanged. Unfortunately the column name must remain "LocalTimestamp".
2. I have also tried exporting it to csv first and then importing it from said csv. The problem is with the INSERT syntax itself, so it still has the exact same error. Exporting the data from SQLite to csv does not cause any issues.
3. I have tried manually writing the INSERT query myself with backticks on the LocalTimestamp and it works.

[Junaid-PK]

Enable reserved-word quoting on the target MySQL driver, rather than putting backticks into the column mapping. DBeaver treats the mapping value as an identifier, so manual backticks there are normalized away.

The setting is under:

1. Database → Driver Manager
2. Select the MySQL driver and choose Edit
3. Open Advanced parameters
4. Under Queries, enable Quote reserved words
5. Reconnect the target connection and rerun the transfer

DBeaver documents that option as automatically quoting table/column names when they conflict with reserved SQL keywords: https://dbeaver.com/docs/dbeaver/Driver-Manager/#queries

After enabling it, use the plain mapping name LocalTimestamp; the generated MySQL insert should contain `LocalTimestamp`. If the existing connection overrides driver settings, duplicate the MySQL driver, enable the option on the duplicate, and point only this migration connection at it.

If this resolves the question, please mark it as the answer so the working solution is easy for future readers to find.

[prabaswara951]

Thank you kindly for your response! I tried to follow your answer but unfortunately couldn't follow through as the settings option Quote Reserved Words under Advanced Parameters of the Driver Manager settings for MySQL does not exist. The only option under the Advanced Parameter tab was Cache Metadata. I am using MySQL library for 26.7 and also tried changing back to 8.10 but the option remains missing. As another note, I have tried using dbeaver 26.2.0 and the problem persists.

I also tried opening the driver settings for MySQL (Old) and MySQL (Legacy). The option for Quote Reserved Words exist in both but were already enabled and has not been changed.

I also tried looking through Driver Properties for the connection configuration itself but was unable to find any settings that may refer to Quoting reserved words.

Is there anything that may have removed the option in question? I'd be happy to provide answers if you need to know more about my settings.