[SQLObject] DBconnection SQL generation error?

[charles b. <li...@st...>]

I think there might be a problem with the way DBConnection generates some
SQL queries.  Specifically, when using SQLObject's createTable function on a
table with a column named "key", mysql will throw an exception since the
generated SQL does not back quote the names of items.

CREATE TABLE table_name (
    id INT PRIMARY KEY AUTO_INCREMENT,
    value VARCHAR(255) NOT NULL UNIQUE,
    key VARCHAR(255) NOT NULL UNIQUE
)

should probably be:

CREATE TABLE `table_name` (
    `id` INT PRIMARY KEY AUTO_INCREMENT,
    `value` VARCHAR(255) NOT NULL UNIQUE,
    `key` VARCHAR(255) NOT NULL UNIQUE
)

I haven't had a chance to investigate further, but I wanted to throw it out
there before I forgot.  Thanks!

-Charles