{"action":"closed","issue":{"url":"https://api.github.com/repos/web2py/web2py/issues/782","labels_url":"https://api.github.com/repos/web2py/web2py/issues/782/labels{/name}","comments_url":"https://api.github.com/repos/web2py/web2py/issues/782/comments","events_url":"https://api.github.com/repos/web2py/web2py/issues/782/events","html_url":"https://github.com/web2py/web2py/issues/782","id":56964584,"number":782,"title":"dal, column names should be in `quotes`","user":{"login":"niphlod","id":122119,"avatar_url":"https://avatars.githubusercontent.com/u/122119?v=3","gravatar_id":"","url":"https://api.github.com/users/niphlod","html_url":"https://github.com/niphlod","followers_url":"https://api.github.com/users/niphlod/followers","following_url":"https://api.github.com/users/niphlod/following{/other_user}","gists_url":"https://api.github.com/users/niphlod/gists{/gist_id}","starred_url":"https://api.github.com/users/niphlod/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/niphlod/subscriptions","organizations_url":"https://api.github.com/users/niphlod/orgs","repos_url":"https://api.github.com/users/niphlod/repos","events_url":"https://api.github.com/users/niphlod/events{/privacy}","received_events_url":"https://api.github.com/users/niphlod/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/web2py/web2py/labels/1%20star","name":"1 star","color":"FFFFFF"},{"url":"https://api.github.com/repos/web2py/web2py/labels/bug","name":"bug","color":"e11d21"},{"url":"https://api.github.com/repos/web2py/web2py/labels/imported","name":"imported","color":"FFFFFF"},{"url":"https://api.github.com/repos/web2py/web2py/labels/Priority-Medium","name":"Priority-Medium","color":"FFFFFF"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-02-08T19:43:36Z","updated_at":"2015-02-10T07:26:16Z","closed_at":"2015-02-10T07:26:16Z","body":"_From [sin..._at_gmail.com](https://code.google.com/u/106405431073557545113/) on January 28, 2015 14:07:56_\n\ndue to outside restrictions i have tables with column names such as `from` `to` `subject` and so forth,\r\n\r\nusing restricted words for column names isn't ideal, but it does work when the column name is in `quotes` or the full column name is used db.table.col\r\n\r\nthe DAL either restricts certain names i.e from.\r\ngenerates broken SQL statements \r\n\r\nUPDATE templates \r\nSET \r\nto = 'abc'\r\nWHERE\r\n    (templates.id = 1);\r\n\r\n\r\ni am using \r\n\r\nVersion 2.7.4-stable+timestamp.2013.11.02.10.08.01\r\n\r\nthis issue can be easily be fixed, by genrating the quoted version of this statement\r\n\r\ni.e\r\n\r\nUPDATE `templates` \r\nSET \r\n`to` = 'abc'\r\nWHERE\r\n    (`templates`.`id` = 1);\r\n\r\nthanks.\n\n_Original issue: http://code.google.com/p/web2py/issues/detail?id=2041_"}}