{"action":"created","issue":{"url":"https://api.github.com/repos/propelorm/Propel2/issues/936","labels_url":"https://api.github.com/repos/propelorm/Propel2/issues/936/labels{/name}","comments_url":"https://api.github.com/repos/propelorm/Propel2/issues/936/comments","events_url":"https://api.github.com/repos/propelorm/Propel2/issues/936/events","html_url":"https://github.com/propelorm/Propel2/issues/936","id":78729803,"number":936,"title":"Using reserved words as column names","user":{"login":"mrjulio","id":1187463,"avatar_url":"https://avatars.githubusercontent.com/u/1187463?v=3","gravatar_id":"","url":"https://api.github.com/users/mrjulio","html_url":"https://github.com/mrjulio","followers_url":"https://api.github.com/users/mrjulio/followers","following_url":"https://api.github.com/users/mrjulio/following{/other_user}","gists_url":"https://api.github.com/users/mrjulio/gists{/gist_id}","starred_url":"https://api.github.com/users/mrjulio/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrjulio/subscriptions","organizations_url":"https://api.github.com/users/mrjulio/orgs","repos_url":"https://api.github.com/users/mrjulio/repos","events_url":"https://api.github.com/users/mrjulio/events{/privacy}","received_events_url":"https://api.github.com/users/mrjulio/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-05-20T22:40:38Z","updated_at":"2015-05-21T19:18:33Z","closed_at":null,"body":"```php\r\nprotected function findPkSimple($key, ConnectionInterface $con)\r\n {\r\n        $sql = 'SELECT id, name, email, group, phone, token, login_at, created_at, status FROM user WHERE id = :p0';\r\n        // ....\r\n}\r\n```\r\n\r\nThe code above was generated in class Base\\UserQuery. As you can see I used `group` word for column name which is a reserved word. I obviously receive a big error when running this. \r\nI believe that this should still work with Propel.\r\n\r\nMaybe there should be a way to auto-detect the string separator from the db config.\r\nI know that with mysql this can be changed via config (`ANSI_QUOTES` if i'm not mistaken).\r\n\r\nAny ideas ?\r\nThank you."},"comment":{"url":"https://api.github.com/repos/propelorm/Propel2/issues/comments/104393172","html_url":"https://github.com/propelorm/Propel2/issues/936#issuecomment-104393172","issue_url":"https://api.github.com/repos/propelorm/Propel2/issues/936","id":104393172,"user":{"login":"SourceCode","id":55036,"avatar_url":"https://avatars.githubusercontent.com/u/55036?v=3","gravatar_id":"","url":"https://api.github.com/users/SourceCode","html_url":"https://github.com/SourceCode","followers_url":"https://api.github.com/users/SourceCode/followers","following_url":"https://api.github.com/users/SourceCode/following{/other_user}","gists_url":"https://api.github.com/users/SourceCode/gists{/gist_id}","starred_url":"https://api.github.com/users/SourceCode/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SourceCode/subscriptions","organizations_url":"https://api.github.com/users/SourceCode/orgs","repos_url":"https://api.github.com/users/SourceCode/repos","events_url":"https://api.github.com/users/SourceCode/events{/privacy}","received_events_url":"https://api.github.com/users/SourceCode/received_events","type":"User","site_admin":false},"created_at":"2015-05-21T19:18:33Z","updated_at":"2015-05-21T19:18:33Z","body":"The problem I see with that is that there are different reserved words in different database engines and at different versions.  Right now I don't believe you tell propel what version of what system you are using and it would probably require those specifics to be able to do this.  I'm just a user though and I thought this same thing then reached the conclusion above as to why it may not make sense to do that or prevent it.  "}}