genconfig doesn't quote column/table names

[joto]

When using the genconfig command, the SQL queries generated do not quote the column/table names. This is necessary if they contain "strange" characters. So either all column/table names should be double quoted or at least those containing non-identifier characters.

https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

[pka]

genconfig tries to generate a human readable configuration and lets quoting to be done by the user:

t-rex/t-rex-core/src/datasource/postgis_ds.rs

Lines 450 to 451 in af2a214

	// Remove quotes from column names for better readability
	.replace('"', "");

Maybe there should be an option for generating a template with quoted column/table names, for cases when there a a log of ugly names.

[joto]

At the moment the query it generates doesn't work and I would consider this a bug. There is also a security consideration here, although minor, because the user should hopefully know what they are doing.

It should be possible to figure out which column names need quoting and which don't and only quote those that need it. This way you get the best of both worlds: A working query and minimal quoting for readability and security.

[pka]

A good compromise would be removing double quotes only if select_list doesn't contain special characters.