Column Names clash with SQL Types

[Gameboard-dev]

Backend

PostgreSQL

What do you want to add to diesel?

Column names "Date", "Time" and possibly "Type" should be prefixed by diesel with i.e., r# to avoid namespace clashing. These are valid columns in some databases.

Implementation notes

No response

Additional details

No response

Checklist

• I have already looked over the issue tracker and the discussion forum for similar possible closed issues.

[weiznich]

We already have a built-in mechanism for handling such collisions: https://github.com/diesel-rs/diesel/blob/main/diesel_cli/src/infer_schema_internals/inference.rs#L13

So it would be simple to add more cases there. We are happy to review a PR for that.

I still would like to see an example what exactly fails with an error message. Maybe it also needs to be fixed somewhere else.