MySQL Query: GUI mode generates wrong column escaping

Hi,

I'd like to do a "Bulk insert" into a MySQL table, using a query in GUI mode.

Everything works fine unless I include columns with a . character in their name, such as BSNr.. In this case, it fails with the following message:

insert into `<table_name>` (`BSNr`.``, `Belegfeld1`, ...) values ('1', NULL, 'EB-Wert', '01.01.2021', NULL, '9000', 'RE', NULL, NULL, '130', NULL, NULL, NULL, '8,808.58') - ER_BAD_FIELD_ERROR: Unknown column 'BSNr.' in 'field list'

As you can see in the query above, the column name seems to be escaped incorrectly to `BSNr`.`` instead of simply `BSNr.`.

Any ideas on how to solve this are highly appreciated!

I think that you can't use a period in a column name