Reserved words cannot be used as column name

[djschilling]

Using the function SPDO::insert reserved words cannot be used as column names.

Example:

SPDO::insert('report', ['rows' => 'Projekt,Hauptkonto'] );

This does not work because rows is a reserved word in new mariadb installations.

SPDO::insert('report', ['`rows`' => 'Projekt,Hauptkonto'] );

This works, cause the column name is in backticks.

A general fix would be to put all column names in backticks.

[milux]

This problem is known, but using backticks for all column names is not a valid solution, because this is MySQL-/MariaDB-specific. (For instance, PostgreSQL uses quotes...)
Instead, I have to implement a method in the connection class that can be adapted for each specific database implementation.